Flexmonster Software License Agreement (“Agreement”) has been significantly revised and is effective as of September 30, 2024.
The following modifications were made:
The modified version of Flexmonster Software License Agreement is available here.
Downloading, installing, and/or continuing to use Flexmonster Software after September 30, 2024, constitutes Licensee’s acceptance of the terms and conditions of the modified version of Flexmonster Software License Agreement. If Licensee does not agree to any of these terms and conditions, they must cease using Flexmonster Software and must not download, install, use, access, or continue to access Flexmonster Software. By continuing to use Flexmonster Software or renewing the license under License Model or Maintenance after the effective date of any modifications to Agreement, Licensee accepts and agrees to be bound by the terms and conditions of the modified Agreement.
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.
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: ascending ("asc" ), descending ("desc" ), or unsorted ("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"}
);
Check out on JSFiddle.
2) Remove sorting of a specific column:
pivot.sortValues(
"columns",
"unsorted",
["category.[bikes]", "color.[red]"],
{"uniqueName": "Price"}
);
See the full code on JSFiddle.