I have a pivot table with three row labels. It shows values for each quarter, by state and year:

Please Login or Register  to view this content.
I'd now like to calculate and show the sum of values for each quarter, by state and year, as in:

Please Login or Register  to view this content.
I've tried showing subtotals for any of the rows, changing the SubTotal calculation settings (e.g., Sum), to no avail. Any suggestions on how to calculate and display the data this way?