This post will guide you how to remove grand total from pivot table in excel 2013/2016. How do I remove column grand totals and row grand total in a pivot table in excel. How to hide grand total in an excel pivot table.
Remove Grand Total
When you created an excel Pivot Table, the grand total will be added automatically by default. So if you do not need the grand total, just follow below steps to remove it:
#1 select one cell in your pivot table
#2 go to DESIGN tab from the toolbar at the top of the screen, click Grand Totals command under Layout group and select Off for Rows and Columns from the popup menu list.
- if you only want to remove column grand total, just select On for Columns Only from the popup menu.
- if you only want to remove or hide row grand total, just select On for Row Only from the popup menu.
#3 you will see that both row and column grand total are removed.