Creating a filter
To create a filter, you define a condition specifying which data rows to display. A filter condition is an If expression that must evaluate to True for a data row to be included. The following list shows examples of possible filter conditions:
If the credit limit is greater than 100000
If the sales office is San Francisco
If the order date is between 4/1/2008 and 6/30/2008
Figure 7‑4 shows an example of a filter condition. When defining a filter condition, you can break it down into the following parts, as shown in
Figure 7‑4:
The column to evaluate, such as credit limit
The comparison operator specifying the type of comparison test, such as Equal To
The value to which all values in the column are compared, such as 100000
Figure 7‑4 Creating a filter
