You are restricted to sorting by a column in the table.
You can hide columns.
Another approach would be to create a view using the two tables which includes the query items you want to expose in the report. That allows you to sort your column by the other column as they would be in the view, and hide those which you do not want to have exposed.
There could be other variables in play which are not mentioned and would affect how one would define the problem and how to deal with it.
I'm not quite sure what "similarity value" means. I'm assuming you mean 'similar value'.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Mon May 30, 2022 12:29 PM
From: Sergio Marinho da Silva
Subject: Cognos dashboard: sort table by column not in table
Hi!
I have a table in Cognos Dashboard that I'd like to have sorted by a column that I do not wish to have in the table.
Is it possible?
(more specifically: I would like to have rows sorted by a similarity value, but the similarity should not be seen by the final user)
------------------------------
Sergio Marinho da Silva
------------------------------
#CognosAnalyticswithWatson