I have two waterfall charts (see below). Right one - running sum of "HXT", left one runing sum of "Total".
I would like to get a percentage of sum of those running totals on the right from the number on the left.
So required output would be (37+72+139+169)/1113 = 37%
In case of (37+35+67+30)/1113 it would be easy...
Any Ideas how to calculate something like that?
Thank you in advance
Why not you are using RUNNING_SUM(SUM([Sales]))/TOTAL(SUM([Sales])) something like below