To use Cognos product documentation, you must enable JavaScript in your browser.

Sort Data

Sorting organizes your data in either ascending or descending alphabetical or numeric order. For example, you can sort on a column that lists product sales in descending order to rank product sales from the highest to the lowest.

When sorting grouped data, you can choose to sort the detail values or you can sort the summary values in the footers.

Steps
  1. Open the report that you want in Query Studio.

  2. Click the heading of the report item you want to sort on.

  3. From the Edit Data menu, click Sort .

  4. In the Sort dialog box, choose the desired sort options.

  5. Click OK.

    A small up or down arrow in the heading indicates sorted data.

Tips