IPivotEvaluatorTotals.LevelTotals

Syntax

LevelTotals: Boolean;

Description

The LevelTotals property determines whether the totals by levels of dimensions are calculated.

Comments

If the property is set to True, totals by levels are displayed on displaying of totals. If the property is set to False, totals are calculated without taking into account dimension levels.

The property is set to True by default.

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. Click the button to start executing the example.

Add links to the Express, Pivot system assemblies.

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

After executing the example, totals (sum of values) are calculated for the table: totals by levels are enabled, grand total, and totals by hierarchy are disabled.