IPivot.ABCColumn

Syntax

ABCColumn: Integer;

Description

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

Comments

Columns indexing starts with zero. To cancel using of "80/20" analysis by columns, assign "-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 this 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