Pivot tables provide a built-in ranking feature, and can rank smallest to largest or largest to smallest.

In the example shown, a pivot table is used to group and rank sales by item.

The pivot table is also sorted by rank so that the top sales items appear first.

Pivot table rank example field configuration

The Amount field has been added twice as a value field.

Pivot table rank example field configuration

Pivot table rank example field configuration

Pivot table rank example field configuration

Pivot table rank example field configuration

Pivot table rank example sales field settings

Pivot table rank example rank field settings

Pivot table rank example sort settings