Business Analytics Connect, learn and share with over 10000 users across the IBM Business Analytics. Join / Log in
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.
I've experienced similar issues. Seems like data tables are still limited in their functionality. If you group a column, it seems to automatically sort it. I've had moderate success defining the sort in the query by setting the "Pre-sort" for the data item. I say moderate success because it doesn't always seem to work, especially if I do the pre-sort on multiple data items.Sorry the response is so late!
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.
Hi Jeremy et al,
I just checked with the dev-team, the functionality of sorting in a data table was considered, but didn't get implemented.You could log an enhancement request and then it can get some visibility for prioritization.