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
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
Rory Archibald
Worked for me. How exactly did you apply it?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
ASKER
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?
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.
That row was there originally but disappeared after I applied the filter, using the steps I mentioned.
ASKER
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!!!
For the record, I did say to right click the Row Labels. ;)