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:
| Sort Order | Description |
|---|---|
| Default | A default sort order is sometimes referred to as the natural order. Depending on the type of data in the column or row, the results are sorted as follows:
|
| Ascending | When selected, the results are arranged in ascending order with the smallest value at the top of the column and the highest value at the bottom. For example, 100, 200, and 300 or California, Colorado, and Florida. |
| Descending | When selected, the results are arranged in descending order with the highest value at the top of the column and the smallest value at the bottom. For example, 300, 200, and 100 or Florida, Colorado, and California. |
| Custom | With a Custom sort, you define your own sort order. Apply the sort to be ascending or descending on columns or rows. An ascending or descending sort impacts only the table in which you apply the sort and is independent of sorts applied to other tables. However, Custom sorts are applied to an object. As a result, all tables in the document that use the object inherit the custom sort. Applying a custom sort sorts the data in the data provider, not just in the table. You can add a temporary value, which does not exist in the database to your document and then include the value in your custom sort. For example, you can add a month 13 to your document for adjustment purposes, even if the value does not exist in the database. Alternatively, you can anticipate the addition of a new store to the database. Before the new store name exists in the database, you can add the value as a temporary value and use the new value as a placeholder for the design of your documents. |
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.
