Chapter 13 Managing Reports

Organizing Report Data

Creating an Aggregate Data Row

To create an aggregate data row:

Step 1 Select a column, then select Aggregation.

The Aggregation dialog box appears. The name of the column you selected is listed in the Selected Column field.

Step 2 From the Select Function menu, select the function you want to use.

The available functions depend on the type of data the column contains:

If the column contains text data, you can count all the values in the column or count the distinct values in the column, for example.

If the column contains numeric data, you can count values, get an average value or a weighted average, total the values in the column, and so on.

The syntax of the selected function appears in the lower portion of the Aggregation dialog box, as shown in Figure 13-40.

Figure 13-40 The Aggregation Dialog Box in Interactive Viewer

Step 3 In the Aggregate on field:

Select whether to display the aggregate value in the table header or the table footer. The default setting is to display the aggregate value in the table footer.

Select whether to display the aggregate value in the group header or group footer, if the selected column is a grouped column.

Step 4 Click Apply.

The aggregate data appears where you placed it in the report design.

 

User Guide for Cisco Secure Access Control System 5.3

13-64

OL-24201-01

Page 428
Image 428
Cisco Systems OL-24201-01 manual Creating an Aggregate Data Row, 13-64