I have a request from a user to be able to sort a report by various totals. The report is a MTD listing of the invoices, showing the totals for product sales, COS, Profit and Margin. It is grouped by customer.
I understand that I can put in a parameter for the user to select. P for sort by Customer Profit, M for sort by Customer Margin...etc, However when I try to use the group sort expert it will not let me use the summary fields for the sorting.
Is there a different way to do this?

Thanks in advance.