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.




      See attahced.