Filtering the value field in a pivot table in Excel
how do I filter the value field in a pivot table. I have a pivot table which gives me all
the clients who purchased different items. I have placed the product in the
column field and filtered it by the product that I want. Now I need to just show
the ones who meet a certain number.
For Example: (Any client who buys 5 or more qualifies)
Client Product Qty
12 7oz 5
14 12oz 5
11 7oz 1
Report should show only the ones with Qty 5
Can anyone help me filter the Value field?
do as in the picture. You can use filter in an excel pivot tables, by right click on the row label.
(for formulas, depending on your country, you might have to change ; with , or the opposite