Data Filter

Modes

Specifies the filtering mode.

Select

Shows the selected rows in the data table in a highlighted state..

Show

Shows the unselected rows with the Hide icon.

Include

Shows the unselected rows with the Exclude icon.

Options

Specifies options for the data filter.

Auto clear

If you have more than one nominal or ordinal column selected in the Data Filter, this option clears any other selections before making a new selection.

Grouped by AND

Enables you to control the AND and OR behavior of multiple groups of column filters.

Conditional

Limits the categories displayed for the selected filter column.

Use Floating Window

Keeps the Data Filter window on top of its associated data table. This option is on by default.

Select Missing

Highlights missing values in the data table.

Display

Specifies display options for categorical columns.

Check Box Display

Shows a check box next to each level.

Show Histograms and Bars

Shows the histogram and bars in the data filter.