cum sum from below

[Anonymous]

Hello!

Have some problem with calculation cumulative sum from below.

There is neccessary result in attached example

i calculate cumulative sum from top by:

rangesum(Above(sum(sales),0,rowno()))

but don't know how to calculate cum sum from below

Thanks for all advices!

[tresesco]

Instead of Above() use it's counter part Below().

Or

Use Above() with negetive offset. Like : =Above(Sum(Sales), -2,0)

[its_anandrjs]

Try with

From above

Rangesum(Above( Sum(sales) ),0, Rowno() )

and for Below or reverse accumulation

Rangesum(Below( Sum(sales) ),0, Rowno() )

[jagan]

Hi,

Please find attached file for solution.

Regards,

Jagan.

[Anonymous]

is your example correct?

i need to show cum sum for each value from below.

In you file you calculate only total cum sum

[Anonymous]

and you calculate only two values every time- previous and next.. i think it's not cum sum

[Anonymous]

it's working some strangely...

from value 1/5/2014 calculation is not correct !

[Anonymous]

it's working some strangely...

from value 1/5/2014 calculation is not correct !

[jagan · Accepted solution]

Hi,

Please find attached file for solution, wrong expression name in the set analysis earlier.

Regards,

Jagan.

[Anonymous]

it's what i need!

thank you!))