How to Sort by Sum Field?

[byrne1]

I want to sort my records by the sum of my customer transactions. How do I do it?

Here's my SQL query so far:

SELECT
CUSTSLS."CustNum", CUSTSLS."TransDateYYYYMMDD", CUSTSLS."StoreNum", CUSTSLS."PriceExtension"
FROM
"CRAFTSMAN"."CUSTSLS" CUSTSLS
WHERE
CUSTSLS."TransDateYYYYMMDD" >= 20050801. AND
CUSTSLS."TransDateYYYYMMDD" <= 20050831.
ORDER BY
CUSTSLS."StoreNum" ASC,
CUSTSLS."CustNum" ASC


My beginning and ending trans dates are parameters and my report only shows a summary of "PriceExtension" for each customer. I want this to be sorted in desc order.

Any ideas???

 

[byrne1]

Nevermind. I figured out that I had to use Report -> Top N/Group Sort Expert. That did the trick.