13-75
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Hiding and Filtering Report Data
Step7 Validate the filter syntax by clicking Validate.
You have now created a filter with one condition. The next step is to add conditions.
Step8 Follow steps Step3 to Step 7 to create each additional desired filter condition.
Step9 In Filters, adjust the filter conditions to achieve the desired filtering. You can combine the conditions in
the following ways:
•Using AND, OR, and NOT
By default, the second filter condition is preceded by AND. AND means that both conditions must
be true for a data row to appear in the report. You can change AND to OR by choosing OR. OR
means that only one condition has to be true for a data row to appear in the report.
If you choose NOT, NOT appears after the AND or OR. NOT means that the condition must be false
for a data row to appear in the report.
•If you add more than one condition, you can use the parentheses buttons to group conditions.
If you enclose two or more filter conditions in parentheses, the conditions in the parentheses are
evaluated first. Then, the entire filter expression is evaluated.
For example, A AND B OR C is evaluated from left to right, so A and B must be true or C must be
true for a data row to appear in the report. In A AND (B OR C), B OR C is evaluated first, so A must
be true and B or C must be true for a data row to appear in the report.

Deleting One Filter Condition in a Filter that Contains Multiple Conditions

To delete a filter condition:
Step1 Select a detail column, then select Filter.
The Filter dialog box appears.
Step2 Click Advanced Filter.
The Advanced Filter dialog box appears. The lower portion of Advanced Filter displays all the filter
conditions in the report.
Step3 Select a filter condition to delete, then click Delete.
Step4 Click Apply.
Filtering Highest or Lowest Values in Columns
When a table contains hundreds of rows, it can be helpful to display the highest or lowest values in a
column. For example, you might want to view the ten sales representatives who produce the most
revenue or the top twenty-five percent of energy consumers.
To perform this type of filter:
Step1 Right-click a selected column, then select Filter > Top or Bottom N
The Top or Bottom N dialog box appears.