How to Find Maximum Value in the Pivot Table

Everybody that uses Excel will find Pivot Tables to be one of the most useful and most used tools. With it, we can observe our data in a lot more powerful way than we do with other tools.

In the example below, we will show how to find the maximum value in our Pivot Table, either being it related to specific fields or in general.

Find Maximum Value in the Pivot Table

For our example, we will use the list of sales of different salespeople in imaginary branches:

Table, Excel

Description automatically generated

To create the Pivot Table, we will select our range, go to Insert >> Tables >> Pivot Table:

Graphical user interface, table, Excel

Description automatically generated

After that, we will simply click OK on the window that appears, and call this new sheet on which Pivot Table will be created “Pivot Table”:

Graphical user interface, text, application, email

Description automatically generated

Once created, we will put Employee in Row Fields and Sales in Values field:

Graphical user interface, application

Description automatically generated

Our table looks like this:

Graphical user interface, text, application

Description automatically generated

An automatic option that Excel presents for Values Field is, as you can see, Sum. So to change it to the maximum value, we can simply left-click on this field in Values and then select Value Field Settings:

Graphical user interface, application

Description automatically generated

On the dialog that appears, we will choose the Max option and click OK:

Graphical user interface, text, application

Description automatically generated

Once we do, our table will show only maximum values for every Employee:

Text, table

Description automatically generated

To find the max value of these four figures, we will click on the dropdown next to the Max of Sales Employee text, and then go to More Sort Options:

Graphical user interface, text, application

Description automatically generated

On the window that appears, we will choose Descending option and then choose Max of Sales as our option:

Graphical user interface, text, application, email

Description automatically generated

Our table looks like this now:

Text, table

Description automatically generated

You will also notice that the number shown in Grand Total is identical to the maximum value. This is yet another, maybe easier way to check the maximum value in your Pivot Table.