1. Modeling
  2. Work with data
  3. Sort data

In a module, use Sort to arrange your rows and columns, and change the view of your data.

To sort: 

  1. In your module, select the column or row you want to sort. 
  2. Select Sort in the toolbar or right-click on the column or row, and select Sort from the menu.  
  3. From the dialog box set the Sort by, Order, Level, and Totals position.
    To find out about the different options for Totals, see Totals position.
    For formatting conventions of Order, see Sort order.
  4. Ensure that the Enable sort checkbox is selected, then select OK

To remove a sort, deselect the checkbox to the right of the Sort icon

To save the new view, select View from the toolbar and then Save As from the dropdown menu. Create your saved view.