Skip to Content

How to Remove Grand Total from a Pivot Table in Google Sheets

By default, a Pivot table in Google Sheets will show a grand total row at the bottom of your pivot table.

Sometimes you may want to completely hide or remove this grand total row from your pivot table, which is pretty easy to do.

In this tutorial, I will show you how to remove grand total from a pivot table in Google Sheets.

Removing Grand Total

Removing the grand total from your pivot table is a pretty easy process.

Here is my pivot table:

Remove grand total-1

You can see the grand total row is at the bottom of the table. This is what I want to remove.

All you have to do to remove the grand total is uncheck the box for “Show totals” in your pivot table editor:

Remove grand total-2

Once the box is unchecked, the grand total row will be completely removed from your pivot table

Remove grand total-3

Closing Thoughts

Removing the grand total is pretty simple once you know where the setting is. This will be especially useful to you if you have a chart created with the pivot table and the grand total also shows up in the chart. You can uncheck this box to completely remove this from your view.

More Google Sheets Tutorials:
How to Format a Pivot Table
How to Refresh a Pivot Table