Sort Datasource Object

Prev Next

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.