I've got a report which calculates some basic profitability off of some of my customers. I'd like the report to sort top down by order of highest dollar amount made. I total up what my costs are and what my profits are for each customer in the customer group footer.

Basically I end up with 2 formulas {@TotCost} and {@TotPrice}. My margin is {@TotPrice} - {@TotCost}...so I'd like to sort based on that formula. However when I create the formula to do that subtraction, it does not appear in the 'Sort' menu. My guess is the way or the location in which the calculation is done is what prevents that. Any suggestions?