Previous Topic
Aggregate On Dialog Box Properties
You can use the Aggregate On dialog box to calculate data in the selected table detail column. This topic describes the options in the dialog box.
Aggregate On
Displays the field that is bound with the detail column. This field is also the one on which the summary is based.
Function
Specifies the function to compute the field in the detail column.
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
Summarizes the detail column data with the specified function and closes the dialog box.
Cancel
Does not retain any changes and closes the dialog box.
Help
Displays the help document about this feature.