How to filter a pivot table by value

Lets take a look.

Here we have an empty pivot table using the same source data weve looked at in previous videos.

Lets add Product as a Row Label, and Total Sales as a Value.

Now lets sort the pivot table by Total Sales in descending order.

This will eliminate all of the products below White Chocolate.

Value Filters are located in the same drop-down menu as Label Filters.

Instead of filtering the label itself, Value Filters work on the values associated with a Label Field.

In this case, we need to choose greater than and then enter 10,000 in the dialog box.

Now the pivot table only shows products with total sales over 10,000.

Lets clear that filter and add a Value Field to count orders.

Because our source data is organized by order, we can determine orders by counting any non-blank field.

Lets use Customer, and then rename the Value Fields to Sales and Orders to make things clear.

Now lets add a new filter to show only products with more than 250 orders.

As before, we navigate to Value Filters, and then select Greater Than.

This time, however we need to switch the Value Filter from Sales to Orders.