Combine Filters

The default filter combination is AND filters. To modify the default filter combination, complete these steps:

Select either OptionsSection Filters or DataSection Filters to open the Section Filters dialog box.
Click Combine Filters to open the Filter Combination dialog box.
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
Click OK.