topic Re: Cumulative Subtotal in Pivot Table in Water Cooler

Cumulative Subtotal in Pivot Table

Wed, 24 Jul 2013 14:48:24 GMT

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,

Wed, 24 Jul 2013 15:38:52 GMT

Hi there,

You can use rangesum function to achieve that

Wed, 24 Jul 2013 16:06:09 GMT

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

Wed, 24 Jul 2013 16:16:22 GMT

Read this

After you undersand this you can make it happen.

Regards