Applying grouping and aggregation to query result columns

Grouping and aggregation options can be applied to query result columns to organize the result data into logical or summarized groupings.

About this task

By adding grouping and aggregation you can automatically obtain summary information about your data and display the data more logically. For example you can roll up data in a report by department or average departmental commissions.

To apply grouping and aggregation to the query result columns:

Procedure

  1. Access the menu of grouping and aggregation options in one of the following ways:
    • With query results in the available editor, select Results > Grouping and Aggregation.
    • If you are using QMF for Workstation, on the Results page of the editor, right-click a column's header cell in the query results and select Grouping and Aggregation from the pop-up menu.
    • From the Display page of the editor, right-click a column name in the Layout structure tree and select Grouping and Aggregation from the pop-up menu.
  2. Select the grouping and aggregation option that you want to apply to the column.
  3. Repeat the process for each column of data in the query results to which you want to add grouping and aggregation.