ValueType: PivotValueType;
The ValueType property determines a format of data view in table.
The specified format is used for the area specified in the IPivot.ValueAreaType property.
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: