Pinterest Pixel

Show Multiple Grand Totals

I’m used to getting Grand Totals that only show the Total Sum in Pivot Table. But I... read more

Download Excel Workbook
Bryan
Posted on

Overview

Show Multiple Grand Totals | MyExcelOnline Show Multiple Grand Totals | MyExcelOnline

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!

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

See also  Show Field and Value Settings in Excel Pivot Tables

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 Show Multiple Grand Totals | MyExcelOnline

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