IPivot.FixedElementsAggregation

Syntax

FixedElementsAggregation: PivotAggregationOperation;

Description

The FixedElementsAggregation property determines aggregation method that is applied on multiple selection in fixed dimensions.

Comments

If the property is set to the PivotAggregationOperatio.None value, aggregation will not be performed and multiple selection of elements will not be available in fixed dimensions.

Example

Executing the example requires a form with the Button1 button, the UiErAnalyzer component named UiErAnalyzer1, and the TabSheetBox and ErAnalyzerDimPanel components that are used for displaying data of an express report. UiErAnalyzer1 is connected to any express report and is a data source for TabSheetBox and ErAnalyzerDimPanel.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    Exp: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    Exp := UiErAnalyzer1.ErAnalyzer;
    Pivot := Exp.Pivot;
    Pivot.FixedElementsAggregation := PivotAggregationOperation.Sum;
End Sub Button1OnClick;

Clicking the button sets an aggregation of values by fixed dimensions of a data source. A multiple selection is available in fixed dimensions. A values sum is calculated for the selected elements.