Previous Topic
Add Aggregation
The Add Aggregation dialog box is used to create or edit a dynamic aggregation in a report. It appears when you expand the Dynamic Resource > Aggregations node in the Resources panel and select <Add Aggregation…>, or right-click a dynamic aggregation and 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 box.
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 box.
OK
Creates or edits the aggregation and closes the dialog box.
Cancel
Cancels the operation and closes the dialog box.
Displays the help document about this feature.
Ignores the setting and closes this dialog box.