The Edit Aggregation dialog helps you to edit the selected dynamic aggregation. It appears when you right-click a dynamic aggregation and then select Edit Aggregation from the shortcut menu in the Data panel of the main window.
The following are details about options in the dialog:
Specifies the name of the aggregation.
Specifies the mapping name of the field to which the aggregation is mapped. Select to select the field.
Specifies the function for the aggregation. When DistinctSum is selected, the following option is available and should be set:
- Distinct On
Specifies the fields according to whose unique values to calculate DistinctSum. Select to select the required fields in the Select Fields dialog.
Edits the aggregation and closes the dialog.
Cancels the editing and closes the dialog.
Displays the help document about this feature.