PivotTable Tools ->Analyze-> PivotTable->
Options
PivotTable Options:
Totals & Filters
2. Try it: Find the Totals & Filters Options
The PivotTable is still selected.
Go to PivotTable Tools ->Analyze->PivotTable.
Click on Options. Go to the Totals & Filters tab.
The Totals & Filters options are shown:
In the Grand Totals section the option to Show grand totals is checked on for both rows and columns (by default).
In the Filters section the option to Allow multiple filters per field is not checked on.
In the Sorting section the option to Use Custom Lists when sorting is checked on. We use Custom Lists to sort months in chronologically (January, February, March) not alphabetically.
Keep going...
