Previous Topic
Add Aggregation Dialog Box Properties
You can use the Add Aggregation dialog box to create a dynamic aggregation object in a report. This topic describes the options in the dialog box.
Aggregation Name
Specifies the display name of the aggregation object.
Mapping Name
After you select 
, Studio displays the Select Resource dialog box. You can then select a field or a formula which the aggregation object is based on. Studio will display the field with its parent node path in the text box.
Aggregate Function
Specifies the aggregate function of the aggregation object. Studio will apply the function to the group where the aggregation is or to the entire report if the aggregation is in the report header or footer.
Distinct On
Studio displays this option and you should set it when you have selected DistinctSum 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 the aggregation object and closes the dialog box.
Cancel
Cancels the creation and closes the dialog box.
Help
Displays the help document about this feature.