Sorting data in the Table View

You can sort data in ascending or descending order in the Table View in the Analysis App window. Data can be sorted by only one column at a time. A sorted column displays either an ascending  or descending  icon in the column header.

To sort data in the Table View:

  1. Do one of the following:
    • Click the header of the column you want to sort.

      Tip

      If you only want to sort data, this method is quickest.

      The sort and filter window opens. You can drag the sort and filter window to any location in the Table View.

    • Click Toggle filter configurations panel .

      The View & Add Filters panel opens.

      If you want to create nested filters in addition to sorting data, you need to use this method.

  2. If you are sorting using a column header, click the Ascending or Descending toggle button.

    The data in the Table View is sorted.

    To remove the sort, click the column header and depending on which type of sort you applied, click the Ascending or Descending toggle button again. You can also switch the sort order.

  3. If you are sorting using the View & Add Filters panel, do the following:
    1. Click the arrow in front of Sort by column.
    2. Click Select field and select a field from the drop-down list.
    3. Click Normal order  (ascending) or Reverse order  (descending).

      The data in the Table View is sorted.

      To remove the sort, click Remove sort . You can also switch the sort order, or select a different column to sort by.

      You can leave the View & Add Filters panel open, or click  in the title bar to close it.

  4. If you want to save the sort order, click the Save drop-down list and select Save.
Related concepts
About the Table View


(C) 2015 ACL Services Ltd. All Rights Reserved.