Cognos Analytics

If you are using a module, you can sort a column in the module.  You can also sort it by setting the sorting rule in the dashboard metadata tree.  The latter can be done on both a module and an uploaded file which is unmediated by being contained in a module

In both cases you can define the sort of the column by the column's values or by the values of another column in the query subject.

You can do this by select the query item and choosing properties from the context menu.

The property which governs sorting is called members. 

Members controls the display of members as well as sorting.

The sort properties are members, sort by, order, and Null values.

Members governs whether sorting and the display of member is enabled, disabled, or automatic, which usually means that the sorting is enabled.

Sort by is a list of the query items in the query subject where the query item is located.

By default, the sort by column will be the query item itself.  This means that the default sort will be by the values of the query item.

You can set the sort by value to any other query item as well.  You could use that to apply a sorting rule which is more appropriate to the nature of the data.  A very simple example of that would be sorting a column with month names in it by another query item which contains the sorting ordinals, as the month names are not alphabetically in the same order as their position in the year.

If you are using a module, you can sort a column in the module.  You can also sort it by setting the sorting rule in the dashboard metadata tree.  The latter can be done on both a module and an uploaded file which is unmediated by being contained in a module

In both cases you can define the sort of the column by the column's values or by the values of another column in the query subject.

You can do this by select the query item and choosing properties from the context menu.

The property which governs sorting is called members. 

Members controls the display of members as well as sorting.

The sort properties are members, sort by, order, and Null values.

Members governs whether sorting and the display of member is enabled, disabled, or automatic, which usually means that the sorting is enabled.

Sort by is a list of the query items in the query subject where the query item is located.

By default, the sort by column will be the query item itself.  This means that the default sort will be by the values of the query item.

You can set the sort by value to any other query item as well.  You could use that to apply a sorting rule which is more appropriate to the nature of the data.  A very simple example of that would be sorting a column with month names in it by another query item which contains the sorting ordinals, as the month names are not alphabetically in the same order as their position in the year.

If you are using a module, you can sort a column in the module.  You can also sort it by setting the sorting rule in the dashboard metadata tree.  The latter can be done on both a module and an uploaded file which is unmediated by being contained in a module

In both cases you can define the sort of the column by the column's values or by the values of another column in the query subject.

You can do this by select the query item and choosing properties from the context menu.

The property which governs sorting is called members. 

Members controls the display of members as well as sorting.

The sort properties are members, sort by, order, and Null values.

Members governs whether sorting and the display of member is enabled, disabled, or automatic, which usually means that the sorting is enabled.

Sort by is a list of the query items in the query subject where the query item is located.

By default, the sort by column will be the query item itself.  This means that the default sort will be by the values of the query item.

You can set the sort by value to any other query item as well.  You could use that to apply a sorting rule which is more appropriate to the nature of the data.  A very simple example of that would be sorting a column with month names in it by another query item which contains the sorting ordinals, as the month names are not alphabetically in the same order as their position in the year.

If you are using a module, you can sort a column in the module.  You can also sort it by setting the sorting rule in the dashboard metadata tree.  The latter can be done on both a module and an uploaded file which is unmediated by being contained in a module

In both cases you can define the sort of the column by the column's values or by the values of another column in the query subject.

You can do this by select the query item and choosing properties from the context menu.

The property which governs sorting is called members. 

Members controls the display of members as well as sorting.

The sort properties are members, sort by, order, and Null values.

Members governs whether sorting and the display of member is enabled, disabled, or automatic, which usually means that the sorting is enabled.

Sort by is a list of the query items in the query subject where the query item is located.

By default, the sort by column will be the query item itself.  This means that the default sort will be by the values of the query item.

You can set the sort by value to any other query item as well.  You could use that to apply a sorting rule which is more appropriate to the nature of the data.  A very simple example of that would be sorting a column with month names in it by another query item which contains the sorting ordinals, as the month names are not alphabetically in the same order as their position in the year.

Hi all,

Have you had any success in sorting a report data table column based on another column? I'm not able to find any additional info outside this thread. We're on version 12 now.

Thanks.