How to sort on SUM Alias

Hello,

I have a query that includes a SUM aggregate alias. Normally i would use a custom query but did it with the normal query manager.

How do i go about sorting on that alias now?

I tried putting values in the SORT and DIR in both the server action and in Server connect. But i don’t think i am doing it right.

Do i just bind SORT to the field and then type DESC in the Order?

Basically i get “column not found: 1054 Unknown column”. I can sort using other columns.

thanks

/J