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…


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:

off for rows & columns

Off for rows & columns pivot

On for rows & columns

On for rows & columns pivot

on for rows

on for rows pivot

on for columns

on for columns pivot

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

remove grand total shortcut

 

HELPFUL RESOURCE:

728x90

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

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn