hpsuser
asked on
Using Custom Filter in Excel pivot table
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!
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!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER