Cumulative Subtotal in Pivot Table

[#1]

Guys,

Need help on this, see below sample pivot table in excel

I need the cumulative subtotal of category

Mon=2

Tue=Mon+Tue(2+3) and so on.

Thanks,

[#2]

Hi there,

You can use rangesum function to achieve that

[#3]

Thanks for the reply,could send the qvw file, I tried doing it but I was not able to do it.

[#4]

Read this

http://community.qlik.com/blogs/qlikviewdesignblog/2012/10/12/accumulative-sums

After you undersand this you can make it happen.

Regards