Creating a filter
When you create a filter, you define a condition that specifies which data rows to include in the report. A filter condition is an If expression that must evaluate to true in order to include a data row. For example:
If the order total is greater than 10000
If the sales office is San Francisco
If the order date is between 4/1/2010 and 6/30/2010
Figure 5‑1 shows an example of a condition defined in Filter. As the illustration shows, Filter helps you define the condition by breaking it down to the following parts:
The column to evaluate, such as Total.
The comparison operator that specifies the type of comparison test, such as Greater Than. For information about all the operators, see
Functions and operators.
The value to which all values in the column are compared, such as 10000.
Figure 5‑1 Filter displaying a filter condition
