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