Next
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. See the topic Creating a Filter for more information.
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. See the topic Filter Conditions for more information.
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. See the topic Adding Multiple Conditions to a Filter for more information.
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):
Save Filter As. Saves the filter as a variable. It can then be applied to other tables.
Move up. Moves the selected filter condition(s) up the list of conditions.
Move down. Moves the selected filter condition(s) down the list of conditions.
Group. Groups the selected filter conditions.
Ungroup. Ungroups the selected filter conditions.
Expand Categories. Displays a dialog box 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.
Level. Selects the level of the filter. This is relevant only if you are using the hierarchical view of the data. Note that if there is another filter defined for a table, there are restrictions on which level you can choose for a new filter. See the topic Setting the Level for a Filter for more information.