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 similar to 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 