Adding a condition
There are two ways to define multiple filter conditions. You can select a column and define a filter, then select the next column and define a filter, and so on. Or you can use the Advanced Filter dialog box, as shown in
Figure 7‑10. You can use Advanced Filter to modify or delete existing filter conditions.
For example, using the former method, you can define two filters, the first on the SALES OFFICE column, the second on the PRODUCTLINE column.
When you use this method to define multiple filters, Interactive Viewer constructs the following filter expression:
SALES OFFICE = San Francisco
and PRODUCTLINE = Vintage Cars
This filter returns only data rows that meet both conditions. Sometimes, you want to create a filter that returns data rows when either condition is true, or you want to create a more complex filter. To accomplish either task, you can use the Advanced Filter dialog box, as shown in
Figure 7‑10.
As the example shows, Advanced Filter provides more options for defining a filter with multiple conditions. It also displays all the filter conditions defined for the report table, or chart element.
Figure 7‑10 Adding a filter condition