How to Remove the Grand Total Line from a Pivot Table

Most time the grand total line is a useful number to have included in a Pivot Table, other times it just needs the boot. In this scenario we are going to get rid of it as it is unwanted and not used for anything we need.

Unwanted PivotTable grand total row.

In order to get rid of the grand total row in our pivot, right click the line and select the Remove Grand Total option. It is that easy!

Removing the grand total line from a pivot.

Here is our result.

summary