1 Reply Latest reply on Mar 21, 2016 8:23 AM by Rajeev Pandey

    Calculate % from two waterfall charts

    Martin Janota

      Hello guys,


      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