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.

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