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

Aggregate Function

Select the function for the aggregation.

If the selected field has a predefined aggregate function, the property name is Aggregation. Server displays the name of the field in the text box, and you cannot edit it.

Distinct On

You should set this property when the aggregate function is DistinctSum. Specify the detail objects according to whose unique values to calculate DistinctSum. Select the ellipsis button to select the detail objects in the Select Fields dialog box.

Label

Specify the label of the new aggregation in the crosstab. You can leave it blank.

Auto Map Field Name

Select if you want to automatically map the label text to the dynamic display name of the field used for the aggregation.

OK

Select to insert the aggregation in the crosstab.

Cancel

Select to close the dialog box without inserting an aggregation in the crosstab.

Select to view information about the dialog box.

Select to close the dialog box without inserting an aggregation in the crosstab.

Back to top

Previous Topic  Next Topic