|
PercentofWeightParent
This aggregate works like PercentofParent, with the difference that a value from one column is compared to a parent level sum of values from another column, which is set as the “Weight column”:
[single child node value from a column] / [sum of all child node values from weight column in the group]
While PercentofParent will always summarize to 100% at the group (parent) level, this is not the case with PercentofWeightParent, which can summarize to any number, depending on the differences between the Values and the Weight Values.
The aggregate value is calculated as a ratio between 0 and 1 and will be presented as a percentage value by applying a percent format string in the aggregation settings.
Sample
|
Group (Parent) |
Member (Child) |
Value |
Weight Value |
Group Sum of Weight Value |
Percent of Weight Parent |
|
G1 |
A |
10 |
20 |
100 |
0.10 |
|
G1 |
B |
15 |
30 |
100 |
0.15 |
|
G1 |
C |
25 |
50 |
100 |
0.25 |
|
G2 |
D |
1 |
1.5 |
5 |
0.20 |
|
G2 |
E |
3 |
1.5 |
5 |
0.60 |
|
G2 |
F |
2 |
2 |
5 |
0.40 |
|
G3 |
G |
14 |
7 |
20 |
0.70 |
|
G3 |
H |
18 |
9 |
20 |
0.90 |
|
G3 |
I |
8 |
4 |
20 |
0.40 |