Previous Next JavaScript must be enabled to correctly display this content

## 4.4.4 Defining an Aggregation in an Interactive Grid

Define an aggregation in an interactive grid by selecting Aggregate from the Actions, Format submenu. Aggregates display after each control break and at the end of the interactive grid within the column for which they are defined.

- Creating an Aggregation in an Interactive Grid
  Create an aggregation in an interactive grid by selecting Aggregate in the Actions, Data submenu.
- Editing an Aggregation in an Interactive Grid
  Edit an existing aggregations by selecting the Aggregate in the Actions, Data submenu.
- Removing an Aggregation in an Interactive Grid
  Use the Aggregate dialog to remove an aggregation.

Parent topic: Customizing an Interactive Grid with the Actions Menu

### 4.4.4.1 Creating an Aggregation in an Interactive Grid

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

To create an aggregation against a column:

1. Click the Actions menu, select Data, then Aggregate.

   The Aggregation dialog appears. (Some fields may be pre-filled.)

   Description of the illustration ig_aggregation_dialog.png
2. In the Aggregation dialog:
   1. Column – Select the column to define against
   2. Aggregation – Select the type of aggregation to apply
   3. Tooltip – (Optional) Add a label that appears when you hover the mouse over the aggregation.
   4. (Optional) Show Overall Value – Select to display the grand total of a column
3. To add another aggregation:
   1. Click the Add icon (+).
      A new Aggregation appears in the list.
   2. Define the new aggregation as described in the previous step.
4. Click Save.

The result of the aggregation appears at the bottom of the last page of the report.

The following example is an interactive grid with two sum aggregations applied to two different columns (a control break has also been applied to simplify the presentation):

Description of the illustration ig_aggregation.png

Parent topic: Defining an Aggregation in an Interactive Grid

### 4.4.4.2 Editing an Aggregation in an Interactive Grid

Edit an existing aggregations by selecting the Aggregate in the Actions, Data submenu.

To edit an aggregation with the Aggregate dialog:

1. Click the Actions menu.
2. Select the Data submenu, then Aggregate.
   The Aggregate dialog displays.
3. Select an aggregation.
4. Edit the aggregation. Editable fields include the column to define against, the function type, Tooltip, and Show Overall Value.
5. Click Save.

Parent topic: Defining an Aggregation in an Interactive Grid

### 4.4.4.3 Removing an Aggregation in an Interactive Grid

Use the Aggregate dialog to remove an aggregation.

Tip:

You can delete or disable an aggregation by interacting with the aggregation filter above the interactive grid. To delete an aggregation, click the Remove Aggregation icon (X); to disable an aggregation, select the adjacent check box.

To remove an aggregation with the Aggregation dialog:

1. Click the Actions menu.
2. Select the Data submenu, then Aggregate.
   The Aggregation dialog displays.
3. Do one of the following:
   - To hide an aggregation from view in the grid, click the adjacent checkbox in the Enabled column. This disables the aggregation and stores it for future use in the Aggregation dialog.
     Description of the illustration ig_aggregation_deselect.png
   - To remove the selected aggregation from the grid completely and permanently, click the Delete icon (—).
     Description of the illustration ig_aggregation_remove.png
4. Click Save.

Parent topic: Defining an Aggregation in an Interactive Grid