Using Custom Filter in Excel pivot table
Posted on 2013-01-10
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?