Previous Topic  Next Topic

Add Aggregation

The Add Aggregation dialog helps you to create or edit a dynamic aggregation in a report. This dialog appears when you expand the Dynamic Resource > Aggregations node in the Resources panel, then select <Add Aggregation…> or right-click a dynamic aggregation and then select Edit from the shortcut menu.

Aggregation Name

Specifies the name of the aggregation.

Mapping Name

Select to select a field or a formula on which the aggregation is based on in the Select Resource dialog.

Aggregate Function

Specifies the function for the aggregation. The function will be applied to the group where the aggregation is placed or the entire report if the aggregation is placed in the report header or footer.

Distinct On

Available and should be set when DistinctSum is selected as the aggregate function. It specifies the fields according to whose unique values to calculate DistinctSum. Select to select the required fields in the Select Fields dialog.

OK

Creates or edits the aggregation and closes the dialog.

Cancel

Cancels the operation and closes the dialog.

Displays the help document about this feature.

Ignores the setting and closes this dialog.

Previous Topic  Next Topic