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

# 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.

• ###### Re: Show Last value for a Cumulative Line

You want to show the value of the expression for the last value of the x-axis dimension. Can't you use max  to test for that? if(max([Rev Months])=[Rev Months],1,0)

• ###### Re: Show Last value for a Cumulative Line

No luck. Tried this. if(max(RevMonth)=RevMonth, Sum({1} TOTAL RevAmt),0)

Seems simple but proving not to be for Cumulative.

I can draw a Cumulative line using this: RangeSum(above(Sum( RevAmt),0,RowNo()))

So I  figured I would use that to Compare against my total value which outputs the correct total. Instead it outputs for every plot point.

• ###### Re: Show Last value for a Cumulative Line

I was able to get this expression to show but plots incorrectly.

If(Sum(  RevAmt) = RangeSum(above(Sum(RevAmt),0,RowNo())) , Sum( TOTAL RevAmt) )

• ###### Re: Show Last value for a Cumulative Line

See attached example

• ###### Re: Show Last value for a Cumulative Line

Nice, I see what you meant before but more so. Instead use the Text vs Show Value. Thanks.