Edit the criteria of a filter, by adding, editing or removing conditions and condition sets.
If the
Filters view is not displayed, select
.
Ensure you have created a filter first (Create a Filter) before following these instructions.
-
In the
Filters view, expand the required filter to show the existing condition sets and conditions.
-
To add a new condition:
-
Select the parent condition set for the new condition, and then click
(New Condition).
The
New Condition dialog box is displayed.
-
Complete the condition details as explained in
Create a Filter.
-
To update existing condition criteria:
-
Right-click the required condition and select
Properties.
The
Condition Properties dialog box is displayed.
-
Complete the condition details as explained in
Create a Filter.
-
To add a new condition set:
-
Select the parent condition set for the new set, and then click
(New Condition Set).
An AND condition set is created by default.
-
If required, click the new set and select
OR to change the type.
-
To delete a condition or condition set:
-
Select the condition or condition set, and then press
Delete.
-
Click
Yes to confirm deletion.
The item is removed from the filter.
Edits to a filter are automatically saved, but if you are editing the active filter, the asterisk next to the filter icon
() indicates you should update the filtered view.
-
click
(Refresh Filtered Results) to reapply the filter to the data file.