Add an advanced filter to filter data by multiple values on columns. After you add an advanced filter, you can edit it to modify the filter values and target columns.
From the Actions menu, click
Edit
Filter
.
The
Edit Mapping Specification
wizard appears.
Select
Advanced Filter
.
On the
Functions
tab, select a function, click the arrow icon and select a column, and click
OK
to add the function to the
Expression
editor.
Optionally, in the
Columns
tab, select a column and click the add icon to add the column to the
Expression
editor.
Select one of the following optional choices to perform a filter task:
Optionally, on the
Rules
tab, select a rule and click the add icon to add the rule column to the
Expression
editor.
Optionally, on the
Lookup
tab, select a lookup and click the add icon to add the lookup column to the