When you insert an Excel Pivot Table and drop a field in the Row/Column Labels you will automatically get a Grand Total.
How about if you want to remove this Grand Total or show it only for a row or column?
Well you have that flexibility and this is how…
STEP 1: Click in your Pivot Table and go to PivotTable Tools > Design > Grand Totals
STEP 2: Choose any of the options below:
SHORTCUT TIP: You can also remove a Grand Total by Right Clicking on the Grand Total heading and choosing Remove Grand Total