You can apply sorts to the values displayed in tables, sections and charts to organize the order in which values are displayed in a report.
By default, the sort starts from the first column.
When you perform sorts, the following sort orders are available:
The order of non-measure objects in a table initially controls the way the data is sorted or grouped in the report.
Uses of Various Sort Orders
The sort feature allows you to format data in ascending or descending order. For example, in a table that shows State, Year, and Sales revenue, you can apply an ascending sort on Year and a descending sort on Sales revenue. The table displays the years in chronological order and within each Year, the Sales revenue displays in descending order.
A default sort uses one of the predefined sort orders described in the table, such as ascending or descending. For example, to sort your sales revenue data so that the state with the highest sales revenue for each year appears first in the group, apply the default descending sort order on Sales revenue.
Custom sorts allow you to define your own order for the data displayed in a report. For example, you can apply a custom sort to display the eFashion month names in chronological order.