The default option in Microsoft Excel is to automatically add a Grand Total Row and Grand Total column to the Pivot Table, which is suitable for most reporting requirements.
However, you can also remove Grand Total Rows and Grand Total Columns from a Pivot Table, if these are not required in your reports or you do not want to show them for any reason.
1. Remove Grand Total in Pivot Table
As you can see in the Pivot Table below, we have the “Subtotals” for products sold by Store#1 and Store#2 and also the “Grand Total” of all the Products sold by the two Stores.
Since, we are only interested in tracking the individual sales made by the two stores, we are going ahead with the following steps to remove Grand Total in this pivot table.
1. Click on any Cell in the Pivot Table and you will see 2 new tabs (Analyze & Design) appearing on the top menu bar.
2. Next, click on the Design tab > click on Grand Totals and select OFF for Rows and Columns option in the drop-down menu.
This will totally remove Grand Totals from your Pivot Table and the Pivot Table will only indicate the subtotals.
2. Hide Column or Row Grand Totals in Pivot Table
As you can see in the image below, we have a Pivot Table showing both Row and Column grand totals. Since, this is not necessary in our case, we are going ahead with the following steps to remove Row Grand Totals in Pivot Table.
1. Click on any Cell in the Pivot Table and you will see 2 new tabs (Analyze & Design) appearing on the top menu bar.
2. Click on the Design Tab > click on Grand Totals and select On for Columns Only option in the drop-down menu.
Now if you take a look at your worksheet, you will only see Column Grand Totals and Row Grand Totals will be removed in the Pivot Table.