13-42
User Guide for Cisco Secure Access Control System 5.4
OL-26225-01
Chapter13 M anaging Reports
Organizing Report Data
Displaying and Organizing Report Data
After you access a data source and select the data set to use, you determine the best way to display the
data in a report. There are several ways to organize data sets:
•Sort a data column in ascending or descending order.
•Organize data into groups. A group displays all the information about a type of item in one place.
For example, you can display all the information about one customer, then all the information about
the next customer, and so on.
•Create aggregate data. At the end of a customer group, for example, you can display the total amo unt
of the customer’s purchases or the average amount of each order. You can also create calculations,
such as sums, standard deviations, rankings, and differences.
Reordering Columns in Interactive Viewer
To reorder columns:
Step1 Select and right-click a column.
Step2 From the context menu, select Column > Reorder Columns.
The Arrange Columns window appears
Step3 Select the column you want to move.
Note You can select only detail rows, not groups or sections.
Step4 Click the up or down arrows at the right until the column is in the correct position.
Step5 Click Apply.

Moving Data Values from Columns to Group Headers

You can move data values from the details rows of a column to column headers.
Step1 Select and right-click on a column.
For example, Figure 13-25 shows the customer Name column as th e selected column.