13-65
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 Managing Reports
Organizing Report Data
Creating an Aggregate Data Row
To create an aggregate data row:
Step1 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.
Step2 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 th e distinct
values in the column, for example.
•If the column contains numeric data, you can c ount 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 Figure13-40.
Figure13-40 The Aggregation Dialog Box in Interactive Viewer
Step3 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.
Step4 Click Apply.
The aggregate data appears where you placed it in the report design.