|
Percent of Parent
For each member item (child node) of a breakdown group (parent node), the percentage share of its value in relation to the parent group value, where the parent group value is calculated as the sum of all group member (child node) values:
[single child node value] / [sum of all child node values in the group]
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) |
Values |
Group Sum |
Percent of Parent |
|
G1 |
A |
20 |
100 |
0.20 |
|
G1 |
B |
30 |
100 |
0.30 |
|
G1 |
C |
50 |
100 |
0.50 |
|
G2 |
D |
1.5 |
5 |
0.30 |
|
G2 |
E |
1.5 |
5 |
0.30 |
|
G2 |
F |
2 |
5 |
0.40 |
|
G3 |
G |
7 |
20 |
0.35 |
|
G3 |
H |
9 |
20 |
0.45 |
|
G3 |
I |
4 |
20 |
0.20 |