Date: Tue, 19 Mar 2024 11:32:01 +0000 (UTC) Message-ID: <1399820801.3312.1710847921048@localhost> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_3311_1756999614.1710847921047" ------=_Part_3311_1756999614.1710847921047 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
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 mem= bers composing parent node. Formula works across drill-down levels and is u= niversal for any depth. Every member has assigned indicator with absolute v= alue which will be used to calculate share within the level.
Final table looks as follows:
Use aggregatePrevLevel to obtain aggregated parent valu= e of current member. Divide actual value by received amount to express shar= e in percentage.
M_SALES= / aggregatePrevLevel(2){M_SALES}