Filter: Does NOT have all of...

[Michael_Morris2]

How can I do a negative filter? Let's say I have a multiple select field with letters A-E. I can easily filter to show all records that contain all of D, E, and F. But I want to filter OUT all records that contain all of D, E, and F. Just D is fine, D and E is fine, etc. 

Thanks for your help!

[Dan_Montoya]

Depending on the field type use “contains” or “any of”. 

[Michael_Morris2]

Thanks Dan for the quick reply. I don't think that would work for my situation. I want to say "Don't use any record with ALL of D, E, and F."

Using "any of" would not allow for records with just D or just D and E.

Using "contains" I believe would have the same results unless I'm missing something. 

[Dan_Montoya]

I meant “does not contain” or “has none of”.  You can use groups to get more complicated filters. 

[Michael_Morris2 · Accepted solution]

I figured it out. My brain hurts trying to figure out why it works, but it works. I grouped: "has none of D or has none of E or has none of F." Thanks for talking me through it.