Pinterest Pixel

Maximum in Excel Pivot Tables

Bryan
In Excel, you can add a new column that displays the maximum in Pivot Tables in just a few clicks.
And this is based on the field that you have selected.

In our example, we want to show the maximum sales amount for each salesperson!

In Excel, you can add a new column that displays the maximum in Pivot Tables in just a few clicks. And this is based on the field that you have selected. In our example, we want to show the maximum sales amount for each salesperson!

 

Exercise Workbook:

download excel workbookMaximum.xlsx


This is our Pivot Table:

Print Excel Pivot Table on two pages

STEP 1: Drag Sales to Values. This will default to become Sum of SALES

Print Excel Pivot Table on two pages

STEP 2: Click on the arrow beside Sum of SALES and select Value Field Settings

Print Excel Pivot Table on two pages

STEP 3: Select Max under Summarize value field by. Click OK

Print Excel Pivot Table on two pages

Now you have the maximum sales value for that specific year, product, and salesperson.

You can quickly check the maximum values here and determine who will get that sweet bonus!

Print Excel Pivot Table on two pages

 

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

If you like this Excel tip, please share it



Maximum 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  Clear & Delete Old Pivot Table Items

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