1. Modeling
  2. Work with data
  3. Sort data
  4. Change sort order

In a module, use Sort to change the display order of columns and rows.

Sort Order can be ascending or descending. To set the sort order, see Sort data.

Sort Order follows these formatting conventions:

  • For text and list data types, the sort is alpha-numeric: blanks, then punctuation marks, then numbers, then A-Z. This order can be reversed.
  • For dates, the sort order is blanks then earliest to latest. This order can be reversed. 
  • If values are tied, the sort order is based on the default order in the list.
  • If a column contains a mix of data types, each data type is considered as a separate group and the sort is applied within the group.
  • For composite hierarchies, each level of the hierarchy is sorted separately.

Disclaimer

We may update our documentation occasionally, but will only do so in a way that does not negatively affect the features and functionality of the Anaplan service.