Skip to Content
0
Dec 08, 2022 at 04:05 PM

Calculating share of a hierarchy node

165 Views

Dear all

I'm using SAC with livedata from BW.
I'm looking for a way to calculate the share of a hierarchy node from another specific (fix) hierarchy node.
In my example below the result I'm looking for would be column D.
As you can see in line 7 I have Sales of 1000 and my goal is to get a share of every other hirarchie node (not matter if it's below or on top of sales) from this 1000.

2022-12-08-p-l-hier.png

Is there any BexQuery formula or function you could recommend? Or maybe there is a way in SAC?
I can create a resticted or calculated key figure for Sales and work with exception aggregation, but nothing worked so far.

Thank you very much for you help!
Stefan

Attachments