I have created a summary report that shows the 140 districts along with margin deterioration as a subtotal field. The subtotal is derived using the sum([Margin])under the [District] footer. The detail section fields are not visible, so all that the report shows is the summary fields in the [District] footer.
Is there a way to sort descending by sum([Margin]) in the [District] footer, so that the worst offices are at the top of the report?
I appreciate any help you can bring to the table.
Is there a way to sort descending by sum([Margin]) in the [District] footer, so that the worst offices are at the top of the report?
I appreciate any help you can bring to the table.