Briefly |
Add the filter to an object with cases in it. The filter starts out empty. To edit it, double-click the filter area at the bottom of the object and use the formula editor. |
Some objects have places for filters. The filters are the white areas at the bottom inside the border.
1. Make the object active by clicking in it. You should see its border.
2. Choose Add Filter from the Data menu. The formula editor appears.
3. Enter the formula. Be sure to enclose any strings in quotes, as in the picture below:
before |
after |
4. Close the formula editor. The object will now show only cases where the filter is true.
5. To remove the filter, choose Remove Filter from the Data menu or edit the filter and erase it.
For complicated filters, you may need Boolean operators (and, or, and not).
Note: Filters are always Boolean expressions.
Other uses of formulas: