5 Replies Latest reply: Mar 25, 2013 2:08 PM by Brian Garside RSS

    Show Last value for a Cumulative Line

      I have a Chart where I want to showthe total cumulative value once its reached at the the end.

       

      I was able to Show Max / Min values for the Bars but NOT the Cumulative.  Any assistance would be great.

       

      The formula I used is this: the first part is to get Rank of 1 test if when it  = Summation then output Total value.

       

      If(Rank(RangeSum(above(Sum( RevAmt),0,RowNo()))) = 1 , Sum({1} TOTAL RevAmt) )

       

      I then use the Show Value option like this.

       

      2013-03-25_112540.png

       

      See attahced.