Is there a way to sort by a SUM field in WebFocus? I have a report that lists loss ratios by Sales Rep Name and Account Name with conditional styling on the loss ratio field that indicates different tolerance levels. I would like this report to come out with the ratios ordered from highest to lowest. Currently, the only solution I know of is to create it in AHTML and allow the user to sort how they see fit, but I would like the default to already be in the highest to lowest order. Suggestions?

This message has been edited. Last edited by: Kerry,

BY TOTAL

Any ideas how to in IBM Webquery? When I try to edit the source and put that command in, the text editor deletes it.

Did you try BY TOTAL sum-field?

TABLE FILE CAR
SUM
COMPUTE RATIO/D5 = RETAIL/DEALER * 100; 
SALES
BY HIGHEST TOTAL RATIO NOPRINT
BY COUNTRY
BY CAR
END