Google Sheets: How to Remove Grand Total from Pivot Table


The easiest way to remove a grand total from a pivot table in Google Sheets is to uncheck the box called Show totals within the Pivot table editor.

The following example shows how to remove the grand total from a pivot table in Google Sheets in practice.

Example: Remove Grand Total from Pivot Table in Google Sheets

Suppose we have the following dataset that shows the total revenue generated by certain products in certain regions for some company:

Step 2: Create the Pivot Table

To create a pivot table that summarizes this dataset, click the Insert tab and then click Pivot table:

In the window that appears, type in the range of the data to use for the pivot table and select a cell in the existing sheet to place the pivot table:

Once you click Create, an empty pivot table will automatically be inserted.

In the Pivot table editor that appears on the right side of the screen, click Add next to Rows and choose Region.

Then click Add next to Columns and click Product.

Then click Add next to Values and click Revenue:

The pivot table will be populated with the following values:

To remove the Grand Total values from the rows and columns, simply uncheck the boxes in the Pivot table editor that say Show totals:

Google Sheets remove grand total from pivot table

Once you do this, the Grand Total values will be removed from the pivot table:

The pivot table now only includes the values inside the table without the grand totals.

Additional Resources

The following tutorials explain how to perform other common operations in Google Sheets:

Google Sheets: How to Format Pivot Tables
Google Sheets: Display Percentage of Total in Pivot Table
Google Sheets: How to Create Pivot Table from Multiple Sheets

One Reply to “Google Sheets: How to Remove Grand Total from Pivot Table”

  1. Google Sheets are just way too basic. The goal is to have a subtotal, but not a Grand Total. There are different uses for different types of totals, but Google sheets over simplified and dumped it all into one. Seems Excel is needed to populate Google Sheets 🙁

Leave a Reply

Your email address will not be published. Required fields are marked *