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.
