Pinterest Pixel

Show Multiple Grand Totals

Bryan
I'm used to getting Grand Totals that only show the Total Sum in Pivot Table.
But I have a quick hack that allows me to have multiple grand totals!
Show Multiple Grand Totals | MyExcelOnline Show Multiple Grand Totals | MyExcelOnline

And on top of that, I can customize what value to show. Read on to see how!

 

Exercise Workbook:

download excel workbookShow-various-Grand-Totals.xlsx


STEP 1: Here is our Pivot Table with multiple Subtotals. However, notice that we only have one Grand Total row.

Show Multiple Grand Totals

To know how to insert subtotals in Pivot Table, Click Here.

STEP 2: Go to our data source and add a blank column GRAND TOTAL:

Show Multiple Grand Totals

STEP 3: Now right-click anywhere on your Pivot Table and select Refresh

Show Multiple Grand Totals

Now the new Grand Total column is now shown there. Drag this to ROWS

Show Multiple Grand Totals

You will see our new row being added here.

Show Multiple Grand Totals

STEP 4: Press the spacebar and then click on any other cell in the Pivot Table.

Show Multiple Grand Totals

STEP 5: Now let’s do our magic! Right-click on that new row and select Field Settings

Show Multiple Grand Totals

Select Custom and pick the functions that you want to display. Click OK.

Show Multiple Grand Totals

STEP 6: We do not need our Grand Total row anymore. Right-click on it and select Remove Grand Total

Show Multiple Grand Totals

Now you have your multiple Grand Totals!

Show Multiple Grand Totals

As you can see, there is no direct way to insert multiple grand totals in Pivot. But you can follow the above mentioned steps and easily insert them in your report.

Click here to learn all about Pivot Tables.

 

Make sure to download our FREE PDF on the 333 Excel keyboard Shortcuts here:

If you like this Excel tip, please share it
Show Multiple Grand Totals | MyExcelOnline
Bryan

Bryan Hong is an IT Software Developer for more than 10 years and has the following certifications: Microsoft Certified Professional Developer (MCPD): Web Developer, Microsoft Certified Technology Specialist (MCTS): Windows Applications, Microsoft Certified Systems Engineer (MCSE) and Microsoft Certified Systems Administrator (MCSA).

He is also an Amazon #1 bestselling author of 4 Microsoft Excel books and a teacher of Microsoft Excel & Office at the MyExecelOnline Academy Online Course.

See also  Printing a Pivot Chart

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