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

      Martin

       

      Capture.PNG