Sorting for table

Adhoc
#1

Hello Helical Insight,

I am unable to sort the table using the icons present there. Note that I already have a specified sort defined in one of the columns. Is there a way to set a default sort? For example, I want sum_total to sort desc on the report by default, but I want a user to be able to still sort by other columns.
You can refer to the below image to understand. Highlighted in yellow color you can see where we have applied sorting by default. Now the other sorting at table level is not working.
image

Thank You,
Sesa.

#2

Hello Sesa,

If you want to have a default sort and still give flexibility for the user to sort by other columns, create a view in which at SQL you have written
apply order by on sum_ total column then create a report using that view. So, you will have sorting applied by sum_total column by default.
Users can use the sorting buttons on top of the table to sort using other columns.
Learn about views : Dynamic Query View in Metadata - Helical Insight

Thank You,
Helical Insight.