How to implement a Cumulative % measure
Good Morning experts,
I am implementing a CR for a customer, RPAS version 15.0.2
I am firstly calculating Sales percent contribution of each store to all store, at department level
Then, based on this I want to rank store descending and calculate a cumulative %.
Department A
SLS Value Relative% Ranking Cumulative %
Store 1 1500 25% 2 =32%+25%=57%
Store 2 600 10% 5 =90%+10%
Store 3 800 13% 4 =77%+13%=90%
Store 4 1900 32% 1 32%
Store 5 1200 20% 3 =57%+20%=77%
I know there is an extended measure %Cumulative Extended measure that does what I need, but extended measures are available only for visualization. On the contrary, I need to use the value of Cumulative % as input for other rules.
Thanks for any hint,
Regards,