Maximum in Excel Pivot Tables | MyExcelOnline

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 WORKBOOK


This is our Pivot Table:

Maximum in Excel Pivot Tables | MyExcelOnline

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

Maximum in Excel Pivot Tables | MyExcelOnline

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

Maximum in Excel Pivot Tables | MyExcelOnline

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

Maximum in Excel Pivot Tables | MyExcelOnline

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!

maximum in pivot

 

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

Facebook

Tweet about this on Twitter

Share on LinkedIn