4.6.8 Defining an Aggregation Against a Column

Define an aggregation against a column with the Actions, Data submenu. Aggregates are displayed after each control break and at the end of the report within the column for which they are defined.

• Creating an Aggregation Against a Column
  Create an aggregation by selecting Aggregate in the Actions, Data submenu.
• Removing a Column Aggregation
  Open the Aggregate dialog to remove an aggregation.

4.6.8.1 Creating an Aggregation Against a Column

Create an aggregation by selecting Aggregate in the Actions, Data submenu.

To create an aggregation against a column:

1. Click the Actions menu and select Data and then Aggregate.
   The Aggregate dialog appears.
2. In the Aggregate dialog:
   1. Aggregation - Select New Aggregation.
   2. Function - Select one of the following: Sum; Average, Count, Count Distinct, Minimum, Maximum, or Median.
   3. Column - Select a column.
      
      Description of the illustration ir_aggreg.png
      This example creates a sum of the Cost column.
   4. Click Apply.
      
      

      
      Description of the illustration ir_aggreg_rpt.png

      
      
      The computation appears at the bottom of the last page of the report. In this example, the aggregate shows the sum of all amounts in the Cost column.

4.6.8.2 Removing a Column Aggregation

Open the Aggregate dialog to remove an aggregation.

To remove column aggregation:

1. Click the Actions menu and select Data and then Aggregate.
   The Aggregate dialog appears.
2. From Aggregation, select a previously defined aggregation.
3. Click Delete.