Can someone tell me how to sort on a sum of a formula field. I have a report that list a group along with the sum for that group. The report now is sorted in ascending order by the group name (GF1). I would like to sort it by the group sum in descending order.
Formula is {spRptSector;1.Bal}/1000
Group Balance = Sum of @Bal
Current sort:
Sector Balance
-------- ------
Services 960,496
Construction 263,769
Stores 494,087
Desired sort:
Sector Sum
-------- ------
Services 960,496
Stores 494,087
Construction 263,769