Filter
Top Products
13-68
User Guide for Cisco Secure Access Control System 5.3
OL-24201-01
Chapter 13 Managing Reports
Hiding and Filtering Report Data
Figure 13-44 Group Detail Rows Displayed
Figure 13-45 shows the results of hiding the detail rows for the creditrank grouping.
Figure 13-45 Group Detail Rows Hidden
• To collapse a group or section, select and right-click a member of the group or section that you want
to collapse.
The context menu appears.
• To display the group members without their detail rows, select Group > Hide Detail.
• To display the group members with their detail rows, select Group > Show Detail.
Working with Filters
Filters limit the data that appears in reports. For example, by using a database of customer data, you can
use filters to run a report that lists only the customers in a specific state or province, or only the
customers whose purchases total more than $1.5 million.
To limit the data even more, you can, for example, list customers in a specific state who have credit limits
of less than $50,000 and who have not made a purchase in the past 90 days.
A filter is based on one or more fields in a report.
To create a filter based on a single field, you select a condition and a value. For example, you can create
a filter that returns values that are equal to a specified value, less than a specified value, between two
values, and so on. Table 13-14 describes the conditions you can select.
Table 13-14 Conditions to Use with Filters
Condition Description
Any Of Returns any of the values you specify.
Between Returns values that are between two specified values. When you select
Between, a second Value field appears for the second default value.