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:
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.
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