I've got a challenging one here. I've been tasked with creating a summary report for all our estimates in a given time period. They want it as a summary by sales rep from highest value to lowest value. Normally this would be fairly straightforward, except that there can be multiple values of an estimate if we quote multiple quantities. I'm solving this by only using the highest value, but that creates a problem with the summary fields.
Right now, I have the report grouped by sales rep, then by estimate. In the group footer of the estimate, I have the max value of the price field. However, I can't use that calculated value as a summary field, which means I can't sort by it. I can't sort by formulas or running totals either.
Any ideas on how to sort groups by a calculated value?