Sort rows by values or names

Sorting rows by values or names makes it easier for you to organize and analyze your data.

Sort options differ depending on the type of data source and the type of exploration. For example, in crosstab that uses an IBM® Cognos® BI multidimensional data source, you can sort rows by row name. Sort by row name is not available with an IBM Cognos TM1® data source.

Procedure

  1. Select a sort option.
    1. To sort rows based on the values in a column, right-click the column header cell then click IBM Cognos Analysis > Sort by value.
    2. In a crosstab that uses an IBM Cognos BI data source, to sort rows by row name, right-click a row header cell then click IBM Cognos Analysis > Sort by name. You can sort rows by name using the context-menu from a row or column box in the overview area.
  2. Select a sort option.

Results

In the overview area, a symbol appears in the rows or columns box to indicate a sort is applied. To remove a sort, right-click the header cell then click IBM Cognos Analysis > Sort > Remove.