The source data contains six fields, but only two fields are used to build the pivot table, Item and Amount:

Item has been added as a Row field. The Amount field has been added twice as a value field. The first instance of Amount has been renamed “Sales” and and set to sum values:

The second instance of Amount has been renamed “Rank”. The rank value is created setting “Show values as” to “Rank largest to smallest”, with Item set as the Base field:

Items are sorted by Rank in Descending order:



Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.   

Pivot table rank example - 4Pivot table rank example - 19Pivot table rank example - 59Pivot table rank example - 23