IPivotEvaluatorTotals.RowTypes

Syntax

RowTypes: Integer;

Description

The RowTypes property determines a type of the totals that are calculated by rows.

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 rows, assign 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;
    Totals := Pivot.Evaluator.Totals;
    Totals.RowTypes := PivotEvaluatorElementType.Sum;
End Sub Button1OnClick;

Clicking the button starts calculation of totals for table or all levels of dimension located by rows: sum of values.

Source data:

Totals by rows: