sortByColumnStringsReverse
Sorts a table region by sorting a single column's values in reverse-alphabetical order.
To achieve the opposite effect, use sortByColumnStrings instead.
Note
Available in "Describe the Table" and "Describe Row in Context" projects only.
Parameters
INPUT TABLE (table region)
The table region to sort.
SORTING COLUMN (string)
The column to sort by. Give the column name as a string.
Note: The column must contain string values only.
Examples
Assume the following table data:
ID | Branch | Sales | Target | |
|---|---|---|---|---|
Row 1 | 1001 | New York | 478,745.37 | 500,000 |
Row 2 | 1002 | Boston | 329,493.49 | 300,000 |
Row 3 | 1003 | Los Angeles | 467,359.45 | 450,000 |
Row 4 | 1004 | Chicago | 463,603.17 | 400,000 |
Note
The first table column — ID in table above — contains the row names.
To sort the table by Branch in reverse-alphabetical order:
[[sortByColumnStringsReverse(WholeTable,'Branch')]]
The result is this sorted table region:
| Branch | Sales | Target |
|---|---|---|---|
1001 | New York | 478,745.37 | 500,000 |
1003 | Los Angeles | 467,359.45 | 450,000 |
1004 | Chicago | 463,603.17 | 400,000 |
1002 | Boston | 329,493.49 | 300,000 |
