|
Percent of Total
For each group and for each group member at all levels of the breakdown hierarchy, the percentage share of its value in relation to the total data set value, where the total is calculated as the sum across all rows in the dataset. This aggregate is like Percent of Parent, with the difference that the denominator or reference is ALWAYS based on the complete dataset:
[single node value] / [sum of all rows in the dataset]
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 1
|
Group (Parent) |
Member (Child) |
Value |
Total Sum |
Percent of Total |
|
G1 |
A |
20 |
125 |
0.16 |
|
G1 |
B |
30 |
125 |
0.24 |
|
G1 |
C |
50 |
125 |
0.40 |
|
G2 |
D |
1.5 |
125 |
0.012 |
|
G2 |
E |
1.5 |
125 |
0.012 |
|
G2 |
F |
2 |
125 |
0.016 |
|
G3 |
G |
7 |
125 |
0.056 |
|
G3 |
H |
9 |
125 |
0.072 |
|
G3 |
I |
4 |
125 |
0.032 |
Sample 1 Aggregated to Group Level
|
Group (Parent) |
|
Group Value |
Total Sum |
Percent of Total |
|
G1 |
|
100 |
125 |
0.80 |
|
G2 |
|
5 |
125 |
0.04 |
|
G3 |
|
20 |
125 |
0.16 |