Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

With Pivot Table Subtotals, we become accustomed to getting the sum as this is the default function used. Did you know that you can create multiple subtotals and use different functions?

This is the full list of the subtotal functions:

  • Sum
  • Count
  • Average
  • Max
  • Min
  • Product
  • Count Numbers
  • StdDev
  • StdDevp
  • Var
  • Varp

 

Exercise Workbook:

DOWNLOAD EXCEL WORKBOOK


Let us now have some fun with multiple subtotals!

STEP 1: This is our Pivot Table. Click on the arrow beside Products

Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

Select Field Settings

Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

STEP 2: Select Custom for the Subtotals option. And you can select Sum, Count, Average, Max, Min to see what happens!

Click OK

Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

Now you have the different subtotals for each Product! You can see that for Bottles and Ice Cubes, the sum, count, average, max and min are all being shown!

multiple subtotals

By following the same steps, you can add or remove other functions including product, count numbers, StdDev, StdDevp, Var and/or Varp!

 

To remove these subtotals, follow the steps below:

STEP 1: Right-click on the row label you want to remove.

Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

STEP 2: Click on subtotal to remove the check mark.

Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

The subtotals will be removed!

Create Multiple Subtotals in Excel Pivot Tables | MyExcelOnline

The subtotals of the field selected will be removed! You can also add multiple grand totals to your Pivot Table, Click here to learn how!

 

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

Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Linkedin