IAxisSet API in Vue Pivot Table API component

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.

enableHyperlink

boolean

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.