Next
You can combine a number of conditions to create complex filters.
As you drag and drop each variable into the Filter pane, the pane builds the conditions that have been defined. Multiple conditions are combined with:
• the And operator, which means that all of the conditions must be true for a case to pass the filter. This is the default. Combine conditions with the And operator when you want cases to be selected if they satisfy all conditions.
• the Or operator, which means that cases will pass the filter if any or all of the conditions are true. Combine conditions with the Or operator when you want cases to be selected if they satisfy either or both of the conditions.
Choose And or Or to add or replace the existing operator.
► If you want to change the order in which a condition appears in the filter after you have added it, highlight the condition in the Filter pane and use the up or down arrow buttons on the Filter toolbar to move it to the correct location.