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

 

 

(c) 2013-2024 Altair Engineering Inc. All Rights Reserved.

Intellectual Property Rights Notice | Technical Support