Add or Remove Grand Total in a Pivot Table

puneet-gogia-excel-champs-09-06-23

- by Puneet

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.

add-remove-grand-total-in-pivot-table

Here is what happens when we create a pivot table.

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.

  1. First, click anywhere on the pivot table to activate the Design Tab.
    activate-the-design-tab
  2. After that, click on the Design tab on the ribbon and look for the Grand Totals.
    click-on-the-design-tab
  3. Here you will find a few options.
    options-under-grand-total
  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.