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.
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!
Here is our result.