Previous Topic  Next Topic

Edit Aggregation Dialog Box

You can use the Edit Aggregation dialog box to edit the selected dynamic aggregation. This topic describes the options in the dialog box.

Designer displays the Edit Aggregation dialog box when you right-click a dynamic aggregation and select Edit Aggregation from the shortcut menu in the Data panel.

You see the following options in the dialog box:

Aggregation Name

Specify the name of the aggregation.

Mapping Name

Specify the mapping name of the field to which the aggregation is mapped. Select the ellipsis to select the field.

Aggregate Function

This drop-down list contains the aggregate functions that you can use for the aggregation. Select the function you need.

• Distinct On
  Designer enables this option and you should set it when you select DistinctSum as the aggregate function. Select the ellipsis to select the fields according to whose unique values to calculate DistinctSum in the Select Fields dialog box.

OK

Select to apply your settings and close the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Previous Topic  Next Topic