Advanced Filter (500)
Posted on 2007-03-28
I have a field with about 7 or 8 unique items and an advanced filter that filters this field. One of the items in the field accounts for the majority of the records. The rest are what I will call "everything else." I need to figure out if there is a way to use the advanced filter to filter on "everything else" without specifying the items in the criteria range. For example if Apples were your best-selling product, you would have a filter that filtered on Apples and Not Apples as your two options. Not Apples needs to return every record that has something other than Apples in that field.