Aggregate data

You can display summary, or aggregate, data within your report. Aggregating data involves applying a calculation on a set of values.

For a simple listing report that does not organise data in groups, you can aggregate calculations on values in a selected column, across all the data rows in a table. For example, consider a report that has a column calculating extended price, price*quantity. You can use the total of the calculations in this column to obtain the total extended price of all items. You can create up to three aggregations for each report column.

Aggregate data can appear in the table header or footer. If the column is grouped, you can display the aggregate value in the group header or footer.

In a report that organises data in groups, you can apply aggregations for each group of data rows, and for all the data rows in the table.

  1. Select and right-click the column containing the data to aggregate.
  2. Select Aggregation. The syntax of the selected function appears in the lower part of Aggregation.
  3. From the Select Function menu, select the aggregate function to use: column name and function syntax. See for a list of functions.
  4. In Aggregate on:
    • Select table level to aggregate data across all the rows in the table.
    • Select either header or footer as the location in which to display the aggregate data.
  5. Select a group or select All groups from the next list to aggregate data at the group level. Select either header or footer as the location in which to display the aggregate data.
  6. Specify a sort direction for the resulting aggregation. If you select Ascending or Descending from the Sort direction list, the groups appear in ascending or descending order in the report. Select None if you do not want to sort the groups in any order.
  7. In Enter Label, enter a label for the aggregation.
  8. (Optional) set a font for the aggregation label by selecting Format.
  9. Click Tap OK.
  1. Click Tap Add Aggregation.
  2. In Select Function, select a function from the list.
  3. Specify a sort direction for the resulting aggregation. If you select Ascending or Descending from the Sort direction list, the groups appear in ascending or descending order in the report. Select None if you do not want to sort the groups in any order.
  4. In Enter Label, enter a label for the aggregation. Optionally, set a font for the aggregation label by selecting Format.
  5. Click Tap OK.

After you create a single aggregate value for a column, you can add up to two more aggregate values for the same column. For an order 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 aggregate rows to a column:

  1. Select a column that contains an aggregate value and select Aggregation from the context menu.
  2. On Aggregation, select Add Aggregation. An additional section appears on Aggregation. You may have to scroll down to make it visible.
  3. Create the second aggregate value and click tap OK.
  4. Create a new aggregate row in this section
  1. Select the column that contains the aggregation to remove.
  2. From the context menu, select Aggregation. Aggregation appears, displaying all the aggregations for the column.
  3. Select Delete Aggregation for the aggregation you want to remove.
  4. Click Tap OK.