Insert Grand Totals to a Pivot Table

https://www.myexcelonline.com/blog/insert-or-delete-rows-and-columns-in-excel/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

If you like this Excel tip, please share it

email

Pinterest

Facebook

Twitter

Linkedin