Pinterest Pixel

Create Multiple Subtotals in Excel Pivot Tables

Bryan
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 workbookCreate-multiple-subtotals.xlsx


Let us now have some fun with multiple subtotals!

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

Print Excel Pivot Table on two pages

Select Field Settings

Print Excel Pivot Table on two pages

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

Click OK

Print Excel Pivot Table on two pages

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!

Print Excel Pivot Table on two pages

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

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

Create Multiple Subtotals in Excel Pivot Tables

The subtotals will be removed!

Create Multiple Subtotals in Excel Pivot Tables

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!

 

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

If you like this Excel tip, please share it



Create Multiple Subtotals in Excel Pivot Tables | 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  Connect Slicers to Multiple Excel Pivot Tables

Star 30 Days - Full Access Star

One Dollar Trial

$1 Trial for 30 days!

Access for $1

Cancel Anytime

One Dollar Trial
  • Get FULL ACCESS to all our Excel & Office courses, bonuses, and support for just USD $1 today! Enjoy 30 days of learning and expert help.
  • You can CANCEL ANYTIME — no strings attached! Even if it’s on day 29, you won’t be charged again.
  • You'll get to keep all our downloadable Excel E-Books, Workbooks, Templates, and Cheat Sheets - yours to enjoy FOREVER!
  • Practice Workbooks
  • Certificates of Completion
  • 5 Amazing Bonuses
Satisfaction Guaranteed
Accepted paymend methods
Secure checkout

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