Filtering Modes
There are three modes of filtering: Select, Show, and Include. You can set and clear these modes using the corresponding check boxes in the Data Filter.
Note: The Select mode is not available for the local Data Filter.
Select
Shows the selected rows in the data table in a highlighted state.
You can turn off the automatic selection of this option using the Data Filter Select Check preference. See also Changing the Row State in the Data Table After Making Data Filter Selections.
Show
Shows the unselected rows with the Hide icon 
.
You can turn on the automatic selection of this option using the Data Filter Show Check preference. For more information about row states, see the Row State Columns in the The Column Info Window section.
Include
Shows the unselected rows with the Exclude icon 
.
You can turn on the automatic selection of this option using the Data Filter Include Check preference. For more information about row states, see the Row State Columns in the The Column Info Window section.
There are two additional options when filtering: Auto clear and Conditional. These options are available from the red triangle menu for the Data Filter. See Red Triangle Options for the Data Filter.