Solved

Pivot table value filter not working

Posted on 2011-03-16
9
1,459 Views
Last Modified: 2012-05-11
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
Comment
Question by:kali958
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35150020
Worked for me. How exactly did you apply it?
0
 
LVL 85

Accepted Solution

by:
Rory Archibald earned 500 total points
ID: 35150027
PS I right-clicked the Row Labels, Value Filter, Greater than, Sum of # Purchased, Greater Than, 500
0
 

Author Comment

by:kali958
ID: 35150352
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
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 

Author Comment

by:kali958
ID: 35150392
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
 
LVL 12

Expert Comment

by:telyni19
ID: 35150704
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35150769
That row was there originally but disappeared after I applied the filter, using the steps I mentioned.
0
 

Author Comment

by:kali958
ID: 35151130
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 35152226
For the record, I did say to right click the Row Labels. ;)
0

Featured Post

Independent Software Vendors: 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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This article describes a serious pitfall that can happen when deleting shapes using VBA.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question