How to filter a pivot table to show top values

Lets take a look.

Here is the same pivot table weve looked at previously, showing Sales and Orders by product.

Lets add a Value Filter on the Product field that limits products to the top 5 products by Sales.

The option we want is called Top 10.

Now simply adjust the controls to display the top 5 items for the Sales field.

The result is a pivot table with 5 rows only - the 5 top products by Sales.

In a similar way, we can adjust the filter to show the 5 bottom products by Sales.

Simply navigate back to the Top 10 filter option, and switch Top to Bottom.

Lets flush the filter and add a new filter to show only the top 3 products by Orders.

Notice that we need to switch the field we’re filtering on from Sales to Orders.

If, however, we move Region above Product, the behavior of the filter changes.

Now, the pivot table shows the top 3 products in each region by Order Count.