Edit a Filter By Using the Edit Filter Window

To edit a filter by using the Edit Filter window:

On the Filters tab, open the drop-down list for the filter that you want to edit and then select Edit Filter. The Edit Filter window appears.

Build the expression for your filter by dragging conditions and operators onto the expression in the right pane.

Conditions for Character Data
=	Specifies that a matching value must match one of the filter values exactly.
Begins with	Specifies that a matching value must contain the filter value at the start of the value.
Contains	Specifies that a matching value must contain the filter value.
Ends with	Specifies that a matching value must contain the filter value at the end of the value.
In	Specifies that a matching value is in the list that you select. To select your list, choose the values from the drop-down list.
Is missing	Specifies that a missing value matches the filter.
Does not contain	Specifies that a matching value must not contain the filter value.
Not In	Specifies that a matching value is not in the list that you select. To select your list, choose the values from the drop-down list.
Is not missing	Specifies that any nonmissing value matches the filter.

Conditions for Continuous Numeric Data
Less than	Specifies that a matching value must be less than the filter value.
Greater than	Specifies that a matching value must be greater than the filter value.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Conditions for Continuous Date and Time Data
Not equal to	Specifies that a matching value must not be equal to the filter value.
Equal to	Specifies that a matching value must be equal to filter value.
Less than	Specifies that a matching value must be less than the filter value.
Less than or equal to	Specifies that a matching value must be less than or equal to the filter value.
Greater than	Specifies that a matching value must be greater than the filter value.
Greater than or equal to	Specifies that a matching value must be greater than or equal to the filter value.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Conditions for Discrete Numeric Data and Date and Time Data
Not equal to	Specifies that a matching value must not be equal to the filter value.
Equal to	Specifies that a matching value must be equal to filter value.
Less than	Specifies that a matching value must be less than the filter value.
Less than or equal to	Specifies that a matching value must be less than or equal to the filter value.
Greater than	Specifies that a matching value must be greater than the filter value.
Greater than or equal to	Specifies that a matching value must be greater than or equal to the filter value.
Between	Specifies that a matching value must be greater than or equal to the first filter value and less than or equal to the second filter value.
In	Specifies that a matching value is in the list that you select. To select your list, choose the values from the drop-down list.
Not In	Specifies that a matching value is not in the list that you select. To select your list, choose the values from the drop-down list.
Is missing	Specifies that a missing value matches the filter.
Is not missing	Specifies that any nonmissing value matches the filter.

Operators for All Data Types
AND	Joins two or more conditions and specifies that a matching value must match all of the conditions.
NOT	Specifies that a matching value must not match the expression that follows NOT.
OR	Joins two or more conditions and specifies that a matching value must match at least one of the conditions.

To add additional conditions to an AND or OR operator, drag a new condition onto the drop zone for the operator. For example, to add a third condition to an AND operator, drag the new condition onto the word AND in the filter expression.

(Optional) For discrete data, click Preview Results to view a preview of the filter results.
For discrete data, select whether to display the visual filter controls on the Filters tab for this filter (Show results in a list of check boxes) or to show a text description of the filter syntax (Apply results as a dynamic rule.)

Note: If your data contains a large number of discrete values, then visual filtering is not available.
When you are finished editing your filter, click OK to apply the filter.