Report Column and Summary Selection

This section describes the process of populating the columns and summary functions in a report. To create a report using the selected universe, click the Report Mode button on the Layout tab. The Selected Items field displays the report layout structure, as shown below.

 

   Figure 222: Report Layout Structure

Within the report you must define between one and 256 columns. Each column you define appears as a column in the report.

Within the report you must define between one and 100 summary functions. Each summary function can display the sum of all numeric values in a column or the number of values in the column.

Selecting Columns

To select a column, expand the universe, as described in Universe Selection and Navigation on page 347.

Select and drag an item or a value from the Select Folder and Items: field to the Selected Items: field and drop it over the area labelled Drag items here to define columns. To create additional columns drop new items next to the existing columns. As the cursor moves over the existing columns a small triangle indicates where the new column will be placed when the item is dropped.

You can select multiple items to drag and drop by holding down the CTRL key whilst clicking the items.

You can change the order of the columns by dragging the column to a new position. The small triangle indicates where the column will be placed when it is dropped.

Selecting Summary Functions

Select a column in the Selected Items: field and drag it to the area labelled Drag items from above to here to define summary functions. You can create up to 100 summary functions in your report.

If the item you drag contains a numeric value, the summary function defaults to Sum. If it contains a non-numeric values, the summary function defaults to Count.

Depending on the data type of the item, you can change the summary function. To change the summary function:

1.   Right-click the summary function and select Summary from the popup menu. The Select Summary Function window is displayed, as shown below.

 

   Figure 223: Select Summary Function Window for a Report

2.   If the data type supports alternative summary functions the Summary function radio buttons are active. Select the radio button for the required summary function. The summary functions are described in the following table.

Table 68: Summary Functions Description

Summary Function Radio Button

Description

Sum

Adds together the numeric values of each item in the column.

Count

Counts the number of items in the column.

Maximum

Returns the value of the highest value item in the column.

Minimum

Returns the value of the lowest value item in the column.

Average

Returns the average value of all items in the column.

3.   The Apply to break levels: field displays the levels for a break report. Select the break levels where you want to add the summary function. Break reports are described in Setting Break Levels on page 374.

4.   If you want to create a Grand Total at the end of the report, select the Add to report level checkbox.

5.   Click OK to apply the changes and close the Select Summary Function window.