• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2190
  • Last Modified:

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
0
kali958
Asked:
kali958
  • 4
  • 3
1 Solution
 
Rory ArchibaldCommented:
Worked for me. How exactly did you apply it?
0
 
Rory ArchibaldCommented:
PS I right-clicked the Row Labels, Value Filter, Greater than, Sum of # Purchased, Greater Than, 500
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now