Cummalitive usage in Pivot table

[#1]

hello All,

I hope you can help.

I have been looking in the forums for a solution to see the cummulative usage in a table.

All the solutions I found are the one that you need to select a month to see the required data.

Below a print screen of a very easy example.

Month Usage Cumm Usage

jan 5 5

feb 10 15

march 10 25

Thanks!

Frank

[#2]

Hi Frank,

try the following:

RangeSum(Usage, Above([Cumm Usage]))

Good luck!

Rainer

[#3 · Accepted solution]

And here the QVW.

Rainer

[#4]

thanks for you fast reply.

I entered your formula in my file but somehow it does not work.

can you help me out?

thanks!

[#5]

Ok, I did some workaroun in my own file.

had to group it by month first.

thanks for you help, toppic closed.

Frank

[#6]

Hi Frank,

here are an working example without scripting (grouping by month).

Have a nice weekend!!!

Rainer