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 an Exploration View that uses a multidimensional data source, you can sort rows by row name.

Please note that within Cognos Analytics, sorting is supported only on the innermost row of a nested Crosstab and is not supported in relational Crosstabs.

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® Planning Analytics > Sort by values.
    2. To sort rows by row name, right-click a row header cell then click IBM Planning Analytics > Sort by names.

      You can also 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 Planning Analytics > Sort by values or Sort by names > Remove.