Sort data in a column

You sort data to display report content in a more meaningful order. You can sort data in ascending or descending order, and you can sort by as many as three fields. For example, you can sort a list of employees by location, then by cost centre, and then by manager name.

  1. Select and right-click the column.
  2. Select Sort > Sort Ascending or Sort Descending.

You can sort data by as many as three columns. When you sort by multiple columns, you use the Advanced Sort glance (also known as a contextual call-out) Provides information and actions in a dialogue box for an item on the screen when the user right-clicks or taps the item.. It is important to understand the order of precedence for a multiple sort action. From the Advanced Sort glance, select the columns in the order in which you want to sort the data. For example, to sort data by location first, then by cost centre, and then by employees within each cost centre, select the columns in that order.

To sort data on multiple columns

  1. Select and right-click a column.
  2. Select Sort> Advanced Sort.
  3. In Advanced Sort glance, in first Sort By field, select a column from the list, then select either Ascending or Descending.
  4. In the first Then By field, select a column from list, then select either Ascending or Descending
  5. In the second Then By field, select a column from list, then select either Ascending or Descending
  6. Click Tap OK.
  1. Select and right-click a column.
  2. Select Sort> Advanced Sort for each column containing sorted data, then click tapSelect a Column from the drop-down list.
  3. Click Tap OK.