IPivot.ValueType

Syntax

ValueType: PivotValueType;

Description

The ValueType property determines a format of data view in table.

Comments

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

Example

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

The example is a handler of the OnClick event for the Button component.

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.

See also:

IPivot