Sorting report based on calculation.

[BIGGY]

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?

[brucevde]

I think you can only sort groups based on a Summary item.

Have you tried the Records -> Top N/Sort Group Expert... menu?

[BIGGY]

Yea I can do a Top N based on the Price at least I guess. Total dollars profited would be nice though.