Selecting a logical operator
As you add each filter condition, Interactive Viewer adds the logical operator AND between each filter condition. You can change the operator to OR. The AND operator means that both filter conditions must be true for a data row to appear in the report. The OR operator means that only one condition has to be true for a data row to appear. You also can add the Not operator to either the AND or OR operators to exclude a small set of data.
For example, the following filter conditions return only sales data for classic car items sold by the San Francisco office:
Sales Office = San Francisco
And Product Line = Classic Cars
The following filter conditions return all sales data for the San Francisco and Boston offices:
Sales Office = San Francisco
Or Sales Office = Boston
The following filter conditions return sales data for all product lines, except classic cars, sold by the San Francisco office:
Sales Office = San Francisco
And Not (Product Line = Classic Cars)