Solved

Using Custom Filter in Excel pivot table

Posted on 2013-01-10
2
671 Views
Last Modified: 2013-01-26
Hello,

I have Excel 2007 and am trying to determine if there is a way to create a custom filter on an Excel pivot table field.  For example, if my pivot table field is "Employee_Tenure", I'd like to be able to say "Between 5 and 10" instead of just manually selecting each value in the list of values for the field?

Not sure if there's a way to do this in Excel 2007, or in future versions?

Thanks!
0
Comment
Question by:hpsuser
2 Comments
 
LVL 7

Accepted Solution

by:
Ross Turner earned 500 total points
ID: 38803159
Hi  Hpuser,

I might have the wrong end of the stick....

In the Pivot Table, click the drop down arrow in the Employee_Tenure field heading.
In the pop-up menu, click Value Filters, then click Between and set your criteria.

Handy Pivot Table Filters

Cheers

ross
0
 

Author Closing Comment

by:hpsuser
ID: 38822668
it does what I want, except not in the Report layout area
0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
Recently Microsoft released a brand new function called CONCAT. It's supposed to replace its predecessor CONCATENATE. But how does it work? And what's new? In this article, we take a closer look at all of this - we even included an exercise file for…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

770 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