IPivot.ValueType

Fore Syntax

ValueType: PivotValueType;

Fore.NET Syntax

ValueType: Prognoz.Platform.Interop.Pivot.PivotValueType;

Description

The ValueType property determines a data view format.

Comments

The specified format is used for the area specified in the ValueAreaType property.

Fore Example

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

Sub Button1OnClick(Sender: Object; Args: IMouseEventArgs);
Var
    OLAP: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    OLAP := UiErAnalyzer1.Instance As IEaxAnalyzer;
    Pivot := OLAP.Pivot;
    Pivot.ValueType := PivotValueType.Percentage;
    Pivot.ValueAreaType := PivotValueArea.Row;
End Sub Button1OnClick;

Clicking the button represents table data in percent format of total value by rows.

Fore.NET Example

Executing the example requires a form with the Button1 button, the TabSheetBoxNet component and the UiErAnalyzerNet component named UiErAnalyzerNet1, which is used as a data source for TabSheetBoxNet.

Imports Prognoz.Platform.Forms.Net;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Pivot;

Private Sub button1_Click(sender: System.Object; e: System.EventArgs);
Var
    OLAP: IEaxAnalyzer;
    Pivot: IPivot;
Begin
    OLAP := UiErAnalyzerNet1.AnalyzerUi.Instance As IEaxAnalyzer;
    Pivot := OLAP.Pivot;
    Pivot.ValueType := PivotValueType.pvtPercentage;
    Pivot.ValueAreaType := PivotValueArea.pvaRow;
End Sub;

On clicking the button table data are presented in percent format of total value by rows.