Filtering the Value field in a Pivot Table

[katiapro93]

I give up! For the past few hours, I have been trying to figure out 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?

 

[sifuzain]

Sounds like you're trying to get the pivot to only show rows where the value is above a certain amount. I don't think it's possible to filter that way using a pivot table.

An alternative might be to sort the values descending from highest to lowest. You need to apply the sort to one/more of your row fields (ther's usually a "more sort options ..." and in there you can choose descending by count of x or sum of y.

And then rather than filter, you could use conditional formatting to highlight values above a certain number. When doing that, be sure (in XL 2007/2010) to apply the conditional formatting to "all fields showing count of x" or "sum of y", then the conditional formatting will be applied to new pivot rows as you add more data

Saved the day! Thank you. Worked like a charm by filtering between values.