Each row and column label can be sorted in ascending or descending order by either the name of the label or by any Fact column in the pivot, providing the flexibility to sort items in a row and column by any column in the dataset. The Sort line in the Pivot section appears different compared to the previously discussed sections due to the additional flexibility provided by the Pivot Sort line for sorting the aggregated information.
The Sort line is toggled to show or hide by clicking on the Sort button at the top of the Section Title Bar. An example of the Sort line is shown in the following screenshot:
Notice the Sort line contains three drop-down boxes. The first is for selecting the row or column label to sort and the second is the column to use to sort the label. The default sort column is Label, which refers to sorting the data by the physical label name. The third drop-down box is for the selection of the data function to use when sorting the data. If the Label option is selected...