13-74
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Hiding and Filtering Report Data
Figure13-47 The Advanced Filter Dialog Box in Interactive Viewer
Advanced Filter provides a great deal of flexibility in setting the filter value. For conditions that test
equality and for the Between condition, you can either set a literal value or you can base the value on
another data column.
For example, you can request actual shipping dates that are greater than the forecast shipping dates, or
actual sales that are less than sales targets. To do this:
Step1 Select a column, then select Filter.
The Filter dialog box appears.
Step2 Click Advanced Filter.
The Advanced Filter dialog box appears. The Filter By field displays the name of the first column in the
report.
Step3 From the Filter By menu, select the column that contains the data you want to filter.
Step4 In the Condition field, select a condition, such as Equal To, Between, or Less Than.
Step5 In Value, select one of the following options:
•Specify literal value—This is the default selection. To specify a literal value, type a value in the
field provided. If you click Select Values, a field appears displaying all data values for the specified
column. For long lists, you can find a value by typing the value in the Filter Text field and clicking
Find.
•Use value from data field—When you select Use value from data field, a drop-down list of columns
appears. The columns in this list have the same data type as the column you selected in the Filter By
field.
Step6 Click Add Condition.
The filter condition appears in Filters.