Menu
Download Free Trial
Table of contents

sortValues

sortValues(axisName:String, type:String, tuple:Array, measureName:String)

[starting from version: 1.4]

Sorts values in a specific row or column in the pivot table.

Parameters

  • axisName – String. The name of the axis to be sorted. It can be 'rows' or 'columns'. In order to define the sorting for numbers in a specific row, put 'rows' as the first parameter. If the API call will define the sorting for a column, put 'columns'.
  • type – String. The type of sorting: 'asc' or 'desc'.
  • tuple – Array. The tuple identifies the column or the row in the table and consists of member’s unique names.
  • measureName – String. Identifies the measure on which sorting will be applied.

Example

flexmonster.sortValues(
	"columns", 
	"asc", 
  	["category.[bikes]", "color.[red]"], 
  	"Price"
);

See also

getSort
setSort