insanity82007
Board Regular
- Joined
- Oct 10, 2007
- Messages
- 130
As the title suggests, how do I do multiple value filters on a row label in a pivot table in Excel 2007/2010?
I can do a label filter and a value filter in conjunction but this is not useful for what I'm trying to do. Does anyone know how I can filter on multiple value fields e.g. field 1 may be incidents from 1 to 10,000 and I want to see anything over 1,000 and field 2 may be a number of days from 1 to 1800 days and I only want to see anything over 365 days. I can't drop these 2 fields into a column, row or filter as they are calculated.
There isn't even and and/or option.
I can do a label filter and a value filter in conjunction but this is not useful for what I'm trying to do. Does anyone know how I can filter on multiple value fields e.g. field 1 may be incidents from 1 to 10,000 and I want to see anything over 1,000 and field 2 may be a number of days from 1 to 1800 days and I only want to see anything over 365 days. I can't drop these 2 fields into a column, row or filter as they are calculated.
There isn't even and and/or option.