Table filters apply to a specific table. You use the Filter pane to define new filters for your tables and to modify existing filters. You can also save filters to use as variables when you create tables.

In the top part of the pane you create a description for the filter. To create a filter, you select variables from the Variables pane and add them to the Filter pane. For more information, see Creating a filter.

The right side of the pane varies according to the type of variable you have selected. You use this area to define the filter condition for the variable. For more information, see Filter conditions.

Below this section is a toolbar, and in the Filter Syntax pane at the bottom of the screen are details of the conditions you have already defined. You can select a condition to change or remove it. For more information, see Adding multiple conditions to a filter.

The Filter menu is available when the Filter tab is visible. It provides the following features (these are also available as buttons on the Filter toolbar):

Saves the filter as a variable. It can then be applied to other tables.

Moves the selected filter conditions up.

Moves the selected filter conditions down.

Groups the selected filter conditions.

Ungroups the selected filter conditions.

Displays a dialog for selecting categories from a categorical variable or categorical grid variable, in cases where there are too many categories to display in the Filter tab without scrolling.

Selects the level of the filter. This is relevant only if you are using the hierarchical view of the data.

If there is another filter defined for a table, there are restrictions on which level you can choose for a new filter. For more information, see Setting the level for a filter.