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 on Pivot Tables
- Add Running Total
- Automatically Update a Pivot Table
- Calculated Field and Item
- Change Data Source for Pivot Table
- Count Unique Values in a Pivot Table
- Delete a Pivot Table
- Filter a Pivot Table
- Add Ranks in Pivot Table
- Apply Conditional Formatting to a Pivot Table
- Pivot Table using Multiple Files
- Group Dates in a Pivot
- Connect a Single Slicer with Multiple Pivot Tables
- Move a Pivot Table
- Pivot Table Formatting
- Pivot Table Keyboard Shortcuts
- Pivot Table Timeline
- Refresh a Pivot Table
- Refresh All Pivot Tables at Once
- Sort a Pivot Table
- Pivot Table from Multiple Worksheets
- Pivot Chart in Excel