Specify Aggregations

To specify an aggregation for a column:

On the Column Editor tab, place your pointer in the Aggregations cell for the column and click. Click the ellipsis button to select the aggregations to use.
In the Choose Aggregations dialog box, select the Aggregate functions radio button.
Select the check boxes for the aggregate functions to use. Click Apply.

Note: After you click Apply, all of the other columns are automatically specified as GROUP BY columns. You can change a column from GROUP BY to an aggregate function by repeating this step for the column.

The following display shows how adding aggregations results in additional output columns. The aggregate function is appended to the column name.

Last updated: January 8, 2019