BackPrevious Topic  Next TopicNext

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 properties in the dialog box.

Aggregate On dialog box

Aggregate On

Server displays the field that is bound with the detail column.

Function

Select the function you use to compute the field in the detail column.

Distinct On

Server enables this property when you have selected DistinctSum as the aggregate function. Select the ellipsis button Choose button to open the Select Fields dialog box. Then, select the required fields according to whose unique values you want to calculate DistinctSum.

OK

Select to summarize the detail column data using the specified function and exit the dialog box.

Cancel

Select to close the dialog box without saving any changes.

Help

Select to view information about the dialog box.

Back to top

BackPrevious Topic  Next TopicNext