jillian728
Active Member
- Joined
- Jun 20, 2003
- Messages
- 250
When I add a field to a pivot table FILTER, there is no option to do a Value Filter (i.e. "less than or equal to"). I want to be able to filter out all values greater than 2 rather than having to go through and uncheck every value greater than 2. When I add this same field to the Row section of the pivot table, the Value Filter option is there when you click the arrow drop down (Screen shot below). However, there is no such option when that field is in the pivot table FILTER section. Is that just not possible?