Another way of organizing data in a table is sorting. By default, report data in a table is not sorted. Note that the sorting in a table is applied to a group. This means that the sorting is performed in the data group where the sorting has been defined.
To sort data
- Click the table to reveal the adorners.
- In the Group section that you want to sort, click the expand button. The section expands to reveal the menu.
- In the expanded menu to the right of the Group, click the drop-down arrow button next to Sort on and select the attribute by which to sort the data. The with A on top option appears below, indicating that the default sort order is ascending.
- You can change the sort order to descending by selecting with Z on top, or select without order to remove the sorting.
See Also