The Sorting option allows for the selection of fields to sort in ascending or descending order by default. Within the report, it is still possible to change the order by sorting clicking on the Column Title. If needed, click on several columns to perform multiple sortings.
The functionality is available through several screens: Main Level Settings, Second Level Settings, Third Level Settings (See BI Tool Main Level Settings) and Details Settings (see BI Tool Details Settings.)
Figure 125: Sorting tab
When the Sort field is applied, the sort direction and order will display on top the report, as indicated in Figure 126. Further, notice Salesperson and ShipperLastName have been clicked to sort those fields and their sort order and direction are also shown.
Figure 126: Sort is direction is indicated.