Edit Aggregate Node

This dialog defines or edits the aggregation elements in the Aggregate node.

To edit an Aggregate node, either double-click the node, or right-click the node and select Edit.

To select the Group By columns or Group By expression, click Edit to launch the Edit Group By dialog.

Now define Aggregation Columns. To use the Aggregation Wizard click launch aggregation wizard
to launch the Define Aggregation wizard. You can also add aggregations one by one.

To edit an already-defined aggregation column, select the aggregation element and click edit selection

to launch the Edit Aggregate Element dialog.

To delete aggregation columns, select them and click delete selected

To add an aggregation column, click add element
to launch the Add Aggregate Element dialog.

To add an expression, launch the Add Aggregate Element dialog by clicking Add aggregate element.

When you have finished defining the aggregation, click OK.