Previous Topic  Next Topic

Insert Aggregation

The Insert Aggregation dialog helps you to add an aggregation in a crosstab based on the selected field.

Aggregate Function

Specifies the function for the aggregation.

If the selected field has been predefined with an aggregate function, the option is Aggregation. The name of the field is displayed in the text box and cannot be edited.

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.

Label

Specifies the label text 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.

Cancel

Does not retain any changes and closes the dialog.

Displays the help document about this feature.

Ignores the setting and closes this dialog.

Previous Topic  Next Topic