topic Cummalitive usage in Pivot table in QlikView

Cummalitive usage in Pivot table

Fri, 23 Oct 2009 19:11:14 GMT

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

Fri, 23 Oct 2009 19:27:51 GMT

Hi Frank,

try the following:

Good luck!

Rainer

Fri, 23 Oct 2009 19:36:13 GMT

And here the QVW.

Rainer

Fri, 23 Oct 2009 19:53:03 GMT

thanks for you fast reply.

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

can you help me out?

thanks!

Fri, 23 Oct 2009 20:27:37 GMT

Ok, I did some workaroun in my own file.

had to group it by month first.

thanks for you help, toppic closed.

Frank

Fri, 23 Oct 2009 20:47:07 GMT

Hi Frank,

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

Have a nice weekend!!!

Rainer