Pivot table sub subtotals

[rezzor]

My data has five columns:

Department | Person's Name | Total # | Month | Year |


I've put it into a pivot table so the rows are department, person's name, Year and the column is Month. It's summing the total number.

When I choose a a sub total for department, I would like it to show the total for each year rather than the default of total of all years. Is this possible? TIA

 

[rezzor]

Ok, I made it work by switching the year into the column and putting the month into the row.

I still do have the general question of: if you have multiple row fields then is it possible to get grand totals of each of the row fields?