Setting Up Data

To open Data group of parameters on the parameters panel:

1. Select a cell or a cell range in the table.

2. Click the Parameters button on the toolbar.

3. Select the Table area type in the drop-down menu of the parameters panel title.

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. Fixed dimensions use aggregation according to the set aggregation methods of source dimensions.

• Average. The average of fixed dimension elements is determined considering empty values.