Maximum in Excel Pivot Tables

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:

---

This is our Pivot Table:

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

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

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

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!

 

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