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…

Insert Grand Totals to a Pivot Table | MyExcelOnline

DOWNLOAD EXCEL WORKBOOK

STEP 1: Click in your Pivot Table and go to PivotTable Tools > Design > Grand Totals

STEP 2: Choose any of the options below:

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

Insert Grand Totals to a Pivot Table

SHORTCUT TIP: You can also remove a Grand Total by Right Clicking on the Grand Total heading and choosing Remove Grand Total

Insert Grand Totals to a Pivot Table

 

728x90

HELPFUL RESOURCES:

JOIN OUR FREE EXCEL COURSES BELOW
Click here to access these FREE Excel courses!

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin