Remove grand totals from a pivot table in Google Sheets
Create a pivot table on a new sheet from A1:D6. Put Region in Rows, Category in Columns, and Revenue in Values summarized by SUM. Turn off Show totals for both the Region row group and the Category column group.
Verified by PhilisAbout 60 secondsCreate a pivot table on a new sheet from A1:D6. Put Region in Rows, Category in Columns, and Revenue in Values summarized by SUM. Turn off Show totals for both the Region row group and the Category column group.
Step-by-step
Select the targetCreate a pivot table on a new sheet from A1:D6.
Complete the next actionPut Region in Rows, Category in Columns, and Revenue in Values summarized by SUM.
Apply the changeTurn off Show totals for both the Region row group and the Category column group.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The pivot table groups by Region and Category, sums Revenue, and hides both row and column grand totals.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select A1:D6 and repeat the final action. The pivot table groups by Region and Category, sums Revenue, and hides both row and column grand totals.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Region | Owner | Category | Revenue |
| North | Anna | Software | 120 |
| South | Ben | Services | 180 |
| North | Cara | Services | 240 |
| West | Dev | Software | 210 |
| South | Eva | Software | 160 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Create a pivot table on a new sheet from A1:D6.
- Complete the next action. Put Region in Rows, Category in Columns, and Revenue in Values summarized by SUM.
- Apply the change. Turn off Show totals for both the Region row group and the Category column group.
- The pivot table groups by Region and Category, sums Revenue, and hides both row and column grand totals.