General
The Sort Datasource Object action sorts the table or pivot table with the defined Sort Specifications.
Properties
Name |
Description |
---|---|
Datasource Object | The Datasource Object to be filtered. |
Sort Specifications | CreateList(<column number>, <"alpha/num">, <"alpha/num">) |
In order to sort by the first measure in a pivot table, use the following:
CreateList(-1, "num", "alpha/num")
Example
To sort a table with 5 columns, 3 dimensions and 2 measures and the 1st, 2nd and 3rd should be sorted alphanumeric, ascending the Sort Specifications are defined as follow:
CreateList(1, "alpha", "asc", 2, "alpha", "asc", 3, "alpha", "asc")
To sort a table with 5 columns, 3 dimensions and 2 measures and the 1st and 2nd columns should be sorted alphanumeric, ascending and the 4rd column should be sorted numeric descending the Sort Specifications are defined as follow:
CreateList(1, "alpha", "asc", 2, "alpha", "asc", 4, "num", "desc")
Available in Version 3.5.20 and higher.