sortValues(axisName: String, type: String, tuple: Array, measure: Object)
[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 the member’s unique names.measure
– Object. Identifies the measure on which sorting will be applied. Has the following properties:
uniqueName
– String. Unique measure name.aggregation
(optional) – String. Measure the aggregation type.Example
flexmonster.sortValues( "columns", "asc", ["category.[bikes]", "color.[red]"], {"uniqueName": "Price"} );
Check out on JSFiddle.
See also