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:

  • Lean In books represents 5.1 % of all Sales.
  • 67.1 % of Lean In were sold via Mobile App and 32.9 % through Mobile Kiosk.
  • 49.1 % of mobile users came from Twitter Premium, 25.1 % from Direct Link, 13.2 % from Bing search and 12.6 % from AdForum.

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