Contents hide
Grand totals appear automatically when you create a pivot table. But sometimes you might find them irrelevant or less important according to your reports. Here’s an example. We have a sales comparison of 2 consecutive years 2018 and 2019.
Here is what happens when we create a pivot table.
Now here you will find that the grand total column is not relevant or in other words does not conclude anything while comparing two consecutive years. Follow the below steps to remove the grand totals from the pivot table.
- First, click anywhere on the pivot table to activate the Design Tab.
- After that, click on the Design tab on the ribbon and look for the Grand Totals.
- Here you will find a few options.
- From there, you can choose the option to Add or Remove Grand totals
- Off for Rows and Columns: Click on this to remove Grand totals for both rows and columns both.
- On for Rows and Columns: If you have hidden or removed your Grand totals, you can bring them back using this option.
- On for Rows only– If you want to display Grand totals only for rows.
- On for Columns only: This will display the Grand totals for your columns only.
More Pivot Table Tutorials
- Add Running Total in a Pivot Table
- Automatically Update a Pivot Table
- Formulas in a Pivot Table (Calculated Field & Item)
- Change Data Source for Pivot Table in Excel
- Count Unique Values in a Pivot Table in Excel
- Delete a Pivot Table in Excel
- Filter a Pivot Table in Excel
- Add Ranks in Pivot Table in Excel
- Apply Conditional Formatting to a Pivot Table in Excel
- Pivot Table using Multiple Files in Excel
- Group Dates in a Pivot in Excel
- Group Dates in a Pivot in Excel
- Connect a Single Slicer with Multiple Pivot Tables in Excel
- Move a Pivot Table in Excel
- Pivot Table Formatting in Excel
- Pivot Table Keyboard Shortcuts
- Pivot Table Timeline in Excel
- Refresh a Pivot Table in Excel
- Refresh All Pivot Tables at Once in Excel
- Sort a Pivot Table in Excel
- Pivot Table from Multiple Worksheets in Excel
- Pivot Chart in Excel
⇠ Back to Pivot Table Tutorial