Filtering the quantity in a Pivot Table

[katiapro93]

I have tried to do a search throughout this board to see if my problem is something that someone else as experienced, but no luck. So, I am hoping someone has some ideas.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have done a pivot table which is laid out as follows:<o></o>
Row labels are the Cust #, Inv. #, & Inv. date (only the cust # is programmed to give me a subtotal) (also they are all set to tabular form)<o></o>
Columns labels are the description of the product (these are filtered for me to pick which ones I want to include).<o></o>
Then the Value label is the quantities a particular customer bought.<o></o>
I have it set for the pivot table to give me a row "Grand total".<o></o>
<o></o>
Now I need to just have the pivot display the "Grand totals" that are above a certain number. See example below:<o></o>
<o></o>
Apples Oranges Pears Grand total<o></o>
Cust 4 Inv 123 1-1-11 2 5 1 8<o></o>
222 2-1-11 1 1 1 3<o></o>
Subtotal for Cust 4 3 6 2 11<o></o>
<o></o>
The 11 is what I want to filter by. In other words, any customer who bought more than 10 is displayed in the pivot if not don't show them.<o></o>
<o></o>
Can this be done?<o></o>

 

[GlennUK]

I think you'd have to do this in 2 stages ... do a countif somewhere to count how many are above 10, then do a Value Filter/Top 10 ... changing the 10 to whatever the result of the count is.

 

[RoryA]

Select a range starting from the column to the right of the pivot table and working back to include the pivot table. Then add an autofilter. Now filter the last column of the PT.

 

[GlennUK]

Select a range starting from the column to the right of the pivot table and working back to include the pivot table. Then add an autofilter. Now filter the last column of the PT.

.... I like it!

 

[katiapro93]

Thank you for the Ideas. I am going to try it and post my results. Thank you!

 

[katiapro93]

It Worked. Thank you, you guys are great!