How to order columns in the report based customly?

Considering date_column is being sorted on a irregular/custom way, below is the solution:

Create a dummy column in answers use the following code in fx

case when monthname(date_column) = 'Jan' then 1 when monthname(Date_column)= 'Feb' then 2 .......... when monthname(Date_column)= 'Dec' then 12 end

enable asc sorting order on this column you can hide this column

Until next post....keep smiling :)