Chapter 13 Managing Reports

Organizing Report Data

Adding Additional Aggregate Rows

After you create a single aggregate row for a column, you can add up to two more aggregate rows for the same column. For an item total column, for example, you can create a sum of all the values, count all the values, and get the average order total.

To add an aggregate row:

Step 1 Select a calculated column that contains an aggregate row, then select Aggregation.

The Aggregation window appears.

Step 2 Click Add aggregation.

An additional section appears in the Aggregation dialog box, as shown in Figure 13-41.

Figure 13-41 Adding an Aggregate Row for a Column in Interactive Viewer

Step 3 Create the second aggregate row, then click Apply.

 

 

User Guide for Cisco Secure Access Control System 5.3

 

 

 

 

 

 

OL-24201-01

 

 

13-65

 

 

 

 

 

Page 429
Image 429
Cisco Systems OL-24201-01 manual Adding Additional Aggregate Rows, Click Add aggregation, 13-65