IPivotEvaluatorTotals.ColumnTypes

Syntax

ColumnTypes: Integer;

Description

The ColumnTypes property determines a type of the totals that are calculated by columns.

Comments

A decimal number that corresponds to the totals type should be assigned as a value of this parameter. Compiling of a totals combination requires indicating of the values sum of the corresponding totals. To cancel the calculation of totals by columns, set this property to 0. The PivotEvaluatorElementType enumerable type contains totals values that can be calculated.

Example

Executing the example requires a form with the button named Button1, the TabSheetBox component and the UiErAnalyzer component named UiErAnalyzer1, which is a data source for TabSheetBox.

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    OLAP: IEaxAnalyzer;
    Pivot: IPivot;
    Totals: IPivotEvaluatorTotals;
Begin
    OLAP := UiErAnalyzer1.ErAnalyzer;
    Pivot := OLAP.Pivot;
    Pivot.Turn;
    Totals := Pivot.Evaluator.Totals;
    Totals.ColumnTypes := PivotEvaluatorElementType.Avg;
End Sub Button1OnClick;

After executing the example clicking the button calculates a total - an average value - for the table at all levels of the dimension that is located by columns.

Source data:

Totals by columns: