Combine Filters

The default filter combination is AND filters. To modify the default filter combination, complete these steps:
  1. Select either Optionsthen selectSection Filters or Datathen selectSection Filters to open the Section Filters dialog box.
  2. Click Combine Filters to open the Filter Combination dialog box.
  3. Select one of these options:
    AND filters
    Select this option if you want to see only observations that match all filters. If there are no observations that match all filters, then no data is returned. This option is the default.
    OR filters
    Select this option if you want to see any observation that matches any of the filters. Data is returned if at least one observation matches at least one filter.
    Custom
    If you choose this option, then you can write a simple, conditional expression that combines your selected filters. In the text field, you can type an expression that includes these items:
    • the names of filters, enclosed in square brackets ([ ])
    • parentheses
    • the words AND and OR to join the names of the filters or items inside parentheses.
    Combine Filters Dialog Box
    Combine Filters Dialog Box
  4. Click OK.