IAxisSet

23 Sep 20252 minutes to read

Allows you to configure the pivot cell information retrieved from the data source.

Properties

actualText number|string

It allows to set the actual text.

actualValue number

It allows to set actual value of the cell.

axis string

It allows to set the axis name of the member.

colIndex number

It allows to set column index to the cell.

colOrdinal number

It allows to set column ordinal of the cell.

colSpan number

It allows to set column span to the cell.

columnHeaders string|number|Date

Specifies the column header of a value cell.

cssClass string

It allows to custom class names to the cell.

dateText number|string

It allows set the formatted date string of the cell.

depth number

It allows to set depth of the cell.

It allows to set the visibility of hyperlink to the cell.

formattedText string

It allows to set the formatted text.

hasChild boolean

It allows to set whether the member has children or not.

hierarchy string

It allows to set whether the member field is a attribute hierarchy or not.

index number[]

Specifies its position collections in data source.

indexObject INumberIndex

Specifies its position collections in data source with indexed object.

isDrilled boolean

It allows to set whether the member is drilled or not.

isGrandSum boolean

Specifies whether the cell is grand summary or not.

isLevelFiltered boolean

Specifies whether the level of the cell is filtered or not.

isNamedSet boolean

It allows to set whether field is a namedset or not.

isSum boolean

Specifies whether the cell is summary or not.

level number

It allows to set level of the member.

levelUniqueName string

It allows to set the parent unique name.

memberType number

It allows to set member type.

members this[]

It allows to set the child members collection of the specific member.

ordinal number

It allows to set the cell ordinal.

parentUniqueName string

It allows to set the parent unique name.

rowHeaders string|number|Date

Specifies the row header of a value cell.

rowIndex number

It allows to set row index to the cell.

rowOrdinal number

It allows to set row ordinal of the cell.

rowSpan number

It allows to set row span to the cell.

showSubTotals boolean

It allows enable/disable sub totals.

style IStyle

It allows to set the style information for conditional formatting.

type string

It allows to set the member type.

value number

It allows to set value of the cell.

valueSort IDataSet

Specifies the data collection which is to be framed for value sorted members.