Can a Equals Filter be applied as an "AND" instead of an "OR"?
The "OR" operator is automatically defined when using certain "EQUAL" type operators.
Scenarios:
1. When the same field is used more than once with "Doesn't Equal (Select)" the "OR" operator is auto defined. This will cancel out the filter and return all values.
Solution: (ex. Ship Country - "Doesn't Equal" - USA, UK, Brazil, Canada)
Not using the "Doesn't Equal (Select)" with drop down will define the "AND" operator for the filter.
2. When the operator "Use Previous OR" is used it will assign the "OR" to each new field this is added to.
Solution: Use "EQUAL" type operators instead for each field. *The "Select" drop down can be used as long as all fields are only used once in like filtering.