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

 

 

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

Intellectual Property Rights Notice | Technical Support