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 WORKBOOK


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

Show Multiple Grand Totals | MyExcelOnline

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

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

Show Multiple Grand Totals | MyExcelOnline

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

Show Multiple Grand Totals | MyExcelOnline

You will see our new row being added here.

Show Multiple Grand Totals | MyExcelOnline

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

Show Multiple Grand Totals | MyExcelOnline

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

Show Multiple Grand Totals | MyExcelOnline

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

Show Multiple Grand Totals | MyExcelOnline

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

Show Multiple Grand Totals | MyExcelOnline

Now you have your multiple Grand Totals!

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.

 

HELPFUL RESOURCE:

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

Microsoft Excel Training

You can learn more about how to use Excel by viewing our FREE Excel webinar training on FormulasPivot TablesPower Query, and Macros & VBA!

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