Hi There,

How can I sort my more than one column using a query table in zoho analytics. I want to sort by business unit, then probability and then by closing date. I have designed a sql statement with an order by clause which works for the design mode but as soon as I switch over to view mode, it looks like all the sorting is disregarded. This is really frustrating as it so nearly works and because I want to do something more complex than the simple one column ascending, descending sorting available in the view mode.

Any help would be appreciated

All the best