Previous Topic
Insert Aggregation Dialog Box Properties
You can use the Insert Aggregation dialog box to add an aggregation in a crosstab based on the selected field. This topic describes the options in the dialog box.
Aggregate Function
Specifies the function for the aggregation.
If the selected field has been predefined with an aggregate function, the option name is Aggregation. Server displays the name of the field in the text box and you cannot edit it.
Distinct On
Available and should be set when DistinctSum is selected as the aggregate function. It specifies the detail objects according to whose unique values to calculate DistinctSum. Select 
to select the detail objects in the Select Fields dialog box.
Label
Specifies the label of the new aggregation in the crosstab. You can leave it blank.
Auto Map Field Name
Specifies whether to automatically map the label text to the dynamic display name of the field used for the aggregation.
OK
Inserts the aggregation and closes the dialog box.
Cancel
Does not retain any changes and closes the dialog box.
Displays the help document about this feature.
Ignores the setting and closes this dialog box.