Thanks for your answer.
Yes, I would like to sort on front end, as it is an expression dimension. I already promote it at the top in Sort tab in the properties. But it dose not work in the QV server side when access the dash from browser. The table is ordered by the first column in the table.