You can use the Add Aggregation dialog box to create a dynamic aggregation object in a report. This topic describes the properties in the dialog box.
Specify the display name of the aggregation object.
Select the ellipsis button to open the Select Resource dialog box. Then, select a field or a formula which the aggregation object is based on. Server displays the field with its parent node in the text box.
Select the aggregate function of the aggregation object. Server applies the function to the group where the aggregation is or to the entire report if the aggregation is in the report header or footer.
Server enables this property when you have selected DistinctSum as the aggregate function. Select the ellipsis button to open the Select Fields dialog box. Then, select the required fields according to whose unique values you want to calculate the DistinctSum function.
Select to create the aggregation object and exit the dialog box.
Select to close the dialog box without creating an aggregation object.
Select to view information about the dialog box.