sortValues

sortValues(axisName: String, type: String, tuple: Array, measure: MeasureIdentifierObject)

[starting from version: 1.4]

Sorts a specific row or column in the compact form, the classic (tabular) form, and the chart view.

Use the setFlatSort method for sorting in the flat form.

Parameters

Parameter/Type	Description
axisName String	Specifies which axis should be sorted: rows (`"rows"`) or columns (`"columns"`).
type String	Specifies the sort order of a row or a column. Possible values: `"asc"`, `"desc"`, and `"unsorted"`.
tuple String[]	Members' unique names that identify a row or a column.
measure MeasureIdentifierObject	Specifies which measure from the slice should be sorted.

1) Sorting a specific column in ascending order:

pivot.sortValues(
  "columns",
  "asc",
  ["category.[bikes]", "color.[red]"],
  {"uniqueName": "Price"}
);

2) Remove sorting of a specific column:

pivot.sortValues(
  "columns", 
  "unsorted",
  ["category.[bikes]", "color.[red]"],
  {"uniqueName": "Price"}
);

See the full code on JSFiddle.