I did a search and could not find this so I have a report that is grouped by a part number. In the grouping footer I created a text box with a calculation that adds up the dollars in that group.
EX the report is sorted and there are 3 order for $10. The total on order for that PN is $30.
I need to sort the report from largest to smallest based on that calculated field. How is the easiest way to do this?