To set up aggregation of several values of table area fixed dimension elements, use the Data group of parameters on the parameters panel:
To open the Data group of parameters
To open Data group of parameters on the parameters panel:
Select a cell or a cell range in the table area.
Click the Parameters button on the toolbar.
Select the Table area type in the drop-down menu of the parameters panel title.
Set the parameters:
Aggregation of fixed dimensions
Aggregation enables the user to combine values of elements selected in fixed dimensions.
To set aggregation, select the method in the drop-down list:
No. No aggregation is executed. Selected by default
Sum. Values of fixed dimensions elements are summed.
Minimum. Minimum value is selected for fixed dimension elements.
Maximum. Maximum value is selected for fixed dimension elements.
From Source Dimensions.
Average. The average of fixed dimension elements is determined considering empty values.
See also:
Setting Up Data Entry Form Formatting and Display Type