IValueSortSettings

12 Sep 20251 minute to read

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

Properties

columnHeaderTextstring

Defines the header text of the column field for which value-based sorting is applied (Relational).
This should represent the exact column member path, separated using the specifiedheaderDelimiter.

Note: Applicable only for relational data sources.

columnIndexnumber

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

columnSortOrderSorting

Sets the sorting order for the specified column header field (Relational).
Available options:

• Ascending - Sorts field members in ascending order based on aggregated value.
• Descending - Sorts field members in descending order based on aggregated value.

Note: Applicable only for relational data sources.

headerDelimiterstring

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

headerTextstring

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

measurestring

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

It is applicable only for OLAP data source.

rowHeaderTextstring

Defines the header text of the row field for which value-based sorting is applied (Relational).
This should represent the exact row member path, separated using the specifiedheaderDelimiter.

Note: Applicable only for relational data sources.

rowIndexnumber

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

rowSortOrderSorting

Sets the sorting order for the specified row header field (Relational).
Available options:

• Ascending - Sorts field members in ascending order based on aggregated value.
• Descending - Sorts field members in descending order based on aggregated value.

Note: Applicable only for relational data sources.

sortOrderSorting

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.