# Pivot table sub subtotals

#### rezzor

##### New Member
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

### Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a \$25,000 loan, 5% annual interest, 60 month loan.

#### rezzor

##### New Member
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?

Replies
3
Views
112
Replies
1
Views
116
Replies
1
Views
107
Replies
2
Views
346
Replies
0
Views
231

1,128,114
Messages
5,628,783
Members
416,338
Latest member
Spartan5305

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back