IPivotEvaluatorTotals.HierarchyTotals

Syntax

HierarchyTotals: Boolean;

Description

The HierarchyTotals property determines whether totals by hierarchy are calculated.

Comments

Available values:

True. Default value. Totals are calculated by hierarchy.
False. Totals are calculated without taking into account hierarchy.

Example

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

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;
    Totals.HierarchyTotals := True;
    Totals.LevelTotals := False;
End Sub Button1OnClick;

After executing this example, the totals (values sum) are calculated for the table by all hierarchy levels.