IPivot.ABCColumn

Syntax

ABCColumn: Integer;

Description

The ABCColumn property determines index of the column, by which the 80/20 analysis is executed.

Comments

Columns indexing starts with zero. To cancel using of 80/20 analysis by columns, assign the -1 value to this property.

NOTE. The property is outdated. To get 80/20 analysis parameters use the Pareto property, to specify index of the column use the ElementIndex property.

Example

Executing the example requires that the repository contains an express report with the EXPRESS_REPORT identifier.

Sub UserProc;

Var

MB: IMetabase;

MObj: IMetabaseObject;

Expr: IEaxAnalyzer;

Grid: IEaxGrid;

Style: IEaxTableStyle;

HeaderStyle, CellStyle: ITabCellStyle;

Begin

MB := MetabaseClass.Active;

MObj := MB.ItemById("EXPRESS_REPORT").Edit;

Expr := MObj As IEaxAnalyzer;

Grid := Expr.Grid;

//header style

HeaderStyle := New TabCellStyle.Create;

HeaderStyle.BackgroundColor := GxColor.FromName("Green");

HeaderStyle.Font.Bold := TriState.OnOption;

//cell style

CellStyle := New TabCellStyle.Create;

CellStyle.BackgroundColor := GxColor.FromName("Yellow");

Style := Grid.Style;

Style.ABCHeaderStyle := HeaderStyle;

Style.ABCStyle := CellStyle;

//A column, by which the analysis is performed

Expr.Pivot.ABCColumn := 2;

MObj.Save;

End Sub UserProc;

After executing the example, formatting styles are changed for header and cells of the column for which the 80/20 analysis is enabled. Analysis is applied to data of the third table column.

See also:

IPivot