IValueSortSettings API in Vue Pivot Table API component

Allows to sort individual value field and its aggregated values either in row or column axis to ascending or descending order.

Properties

columnIndex

number

It allows to set the column index of the value cell.

headerDelimiter

string

It allows to set the delimiter, which is used a separator to split the given header text.

headerText

string

It allows to set the member name of a specific field for value sorting.

measure

string

It allows to set the measure name to achieve value sorting based on this.

It is applicable only for OLAP data source.

sortOrder

Sorting

Allows to apply sorting to the specified field either by ascending or descending. The types are,

• Ascending: It allows to display the field members in ascending order.
• Descending: It allows to display the field members in descending order.