RSUM Function
630635Jun 26 2008 — edited Aug 29 2008How do I control where to place a break on the cumulative function. For eg., if I have a drop-down for a region and a quarter in my pivot table, and I have to show the data as cumulative of the weeks within the quarter, how can I do it without the RSUM function summing up beyond the weeks in a particular quarter. How can I make it to break after one quarter and start summing afresh in the next?
I know it can be done by unioning each quarter, but this will not help if its some other dimension with many values.