Pinterest Pixel

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... read more

Download Excel Workbook
John Michaloudis
Posted on
Customize Pivot Table TutorialsExcel Pivot Tables Tutorials

Overview

Insert Grand Totals to a Pivot Table | MyExcelOnline Insert Grand Totals to a Pivot Table | MyExcelOnline

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 workbookGrandTotals.xlsx

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

If you like this Excel tip, please share it
LinkedInCopyPrintReddit
Insert Grand Totals to a Pivot Table | MyExcelOnline Insert Grand Totals to a Pivot Table | MyExcelOnline
Insert Grand Totals to a Pivot Table | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Sum vs Count in Pivot Table

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!
Share to...
BufferCopyFlipboardHacker NewsLineLinkedInMastodonMessengerMixPinterestPocketPrintRedditSMSTelegramThreadsTumblrVKWhatsAppXingYummly