how to get a previous value in a text object

[Anonymous]

Hi,

I have a field D which has values 1 to 20

Now i created a Text object in that if i select an value 7.The previous value of 7 i.e., 6 want to appear on the text object please clarify my doubt.

Thanks in advance.

[Anonymous]

wow great !!

Thank you for your answer...!!

[Anonymous]

Sorry Another Question what we want to do If I want the same answer in pivot table..coz Accumulation is not available in pivot chart..

[bbi_mba_76]

You could try with something of similar

=rangesum(Sum(D),above(Sum(D),1,rowno()))

[Anonymous]

Thanks a Lot..:)