Cisco Systems OL-24201-01 manual Working with Filters, Condition Description, 13-68

Chapter 13 Managing Reports

Hiding and Filtering Report Data

Figure 13-44 Group Detail Rows Displayed

Figure 13-45shows 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-14describes 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.
	User Guide for Cisco Secure Access Control System 5.3
13-68			OL-24201-01