PercentofWeightTotal
This aggregate works like PercentofTotal, with the difference that a value from one column is compared to a total data set level sum of values from another column, which is set as the “Weight column”:
[single node value from a column] / [sum of all rows from weight column in the dataset]
While PercentofTotal will always summarize to 100% across the whole data set, this is not the case with PercentOfWeightTotal, 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 1
Group (Parent) 
Member (Child) 
Value 
Weight Value 
Group Sum of Weight Value 
Percent of Weight Total 
G1 
A 
10 
20 
125 
0.08 
G1 
B 
15 
30 
125 
0.12 
G1 
C 
25 
50 
125 
0.20 
G2 
D 
1 
1.5 
125 
0.008 
G2 
E 
3 
1.5 
125 
0.024 
G2 
F 
2 
2 
125 
0.016 
G3 
G 
14 
7 
125 
0.112 
G3 
H 
18 
9 
125 
0.144 
G3 
I 
8 
4 
125 
0.064 
Sample 1 Aggregated to Group Level
Group (Parent) 
Member (Child) 
Value 
Weight Value 
Group Sum of Weight Value 
Percent of Weight Total 
G1 
50 
100 
125 
0.40 

G2 
6 
5 
125 
0.048 

G3 
40 
20 
125 
0.32 