Need help on this, see below sample pivot table in excel
I need the cumulative subtotal of category
Tue=Mon+Tue(2+3) and so on.
You can use rangesum function to achieve that
Thanks for the reply,could send the qvw file, I tried doing it but I was not able to do it.
After you undersand this you can make it happen.
Retrieving data ...