Creating Complex Filter Criteria with the Filter Control
To build complex filter criteria with an unlimited number of filter conditions, combined by logical operators, use the built-in Filter Control.
To open the Filter Control, click one of the following.
the filter image displayed within the filter bar.
the filter expression link.
To create and customize filter criteria, use the and buttons embedded into the control:
Remarks
A filter condition group is a set of conditions combined by the same logical operator. The following filter expression contains two groups combined by the logical OR operator: "(Country Equals 'UK' And Category Equals 'Beverages') Or (Country Equals 'USA' And Category Equals 'Produce')". In the Filter Control, it is represented as follows.
To learn more, see the Filter Editor topic.