Reporter > Filtering results > Table filters
 
Table filters
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 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 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 Adding multiple conditions to a filter for more information.
Filter menu
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 If there is another filter defined for a table, there are restrictions on which level you can choose for a new filter. See Setting the level for a filter for more information.
See also
Category Selection dialog box
Filtering results