It is recommended to get familiar with aggregatePrevLevel function and its variations before proceeding with this tutorial.

The goal of this tutorial is to display percentual share of children members composing parent node. Formula works across drill-down levels and is universal for any depth. Every member has assigned indicator with absolute value which will be used to calculate share within the level.

Final table looks as follows:


Use aggregatePrevLevel to obtain aggregated parent value of current member. Divide actual value by received amount to express share in percentage.

M_SALES / aggregatePrevLevel(2){M_SALES}

Next Steps