Add or Remove Grand Total in a Pivot Table

HomePivot TableAdd or Remove Grand Total in a Pivot Table

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 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 to anything while comparing two consecutive years. Follow the below steps to remove the grand totals from the pivot table.

  1. First, click anywhere on the pivot table to activate the Design Tab.
  2. After that, click on the Design tab on the ribbon and look for the Grand Totals.
  3. Here you will find a few options.
  4. From there, you can choose the option to Add or Remove Grand totals
    1. Off for Rows and Columns: Click on this to remove Grand totals for both rows and columns both.
    2. On for Rows and Columns: If you have hidden or removed your Grand totals, you can bring them back using this option.
    3. On for Rows only– If you want to display Grand totals only for rows.
    4. On for Columns only: This will display the Grand totals for your columns only.

More on Pivot Table

Sort a Pivot Table | Refresh a Pivot Table | Pivot Table Keyboard Shortcuts | Pivot Table Formatting |Move a Pivot Table | Filter a Pivot Table | Count Unique Values in a Pivot Table | Change Pivot Table Data Source | Add Ranks in Pivot Table | Insert Calculation in Pivot Table | Refresh All Pivot Tables  | Automatically Update a Pivot Table | Running Total in a Pivot Table | Conditional Formatting to a Pivot Table | Pivot Table from Multiple Worksheets | Group Dates in a Pivot Table | Connect a Slicer with Multiple Pivot Tables | Pivot Table Timeline