Pivot table value filter not working

Could anyone tell me why the value filter doesn't work in excel pivot tables?  The instruction seem pretty straightforward and easy, but when I apply a filter, nothing changes.  What am I doing wrong?  

The attached is a generic example.  There are two pivot tables, one without the filter and one with the filter applied.  Any ideas? Value-Filter-Issue.xlsx
kali958Asked:
Who is Participating?
 
Rory ArchibaldConnect With a Mentor Commented:
PS I right-clicked the Row Labels, Value Filter, Greater than, Sum of # Purchased, Greater Than, 500
0
 
Rory ArchibaldCommented:
Worked for me. How exactly did you apply it?
0
 
kali958Author Commented:
That's what I did, but it doesn't change the pivot table at all. I still see exactly the same thing. It's driving me crazy because it seems so easy and would be incredibly helpful, but nothing changes. Could there be a setting somewhere that I need to check?  
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
kali958Author Commented:
Did the second pivot table with the filter applied have the Broccoli & Cheese row when you opened my file?  Or did you have to apply it after you opened it for the Broccoli & Cheese row to be removed?
0
 
telyni19Commented:
Just to confirm what rorya said, his method works fine. The Broccoli & Cheese row was visible in the second pivot table and disappeared after applying the filter.
0
 
Rory ArchibaldCommented:
That row was there originally but disappeared after I applied the filter, using the steps I mentioned.
0
 
kali958Author Commented:
Okay, I think I know what I was doing wrong.  I was trying to apply the value filter to the # Purchased, but I should have been applying it to the soup. It works now.  Thank you!!!
0
 
Rory ArchibaldCommented:
For the record, I did say to right click the Row Labels. ;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.