We would like to know if there is a way to sort a field in descending order that is neither in the DataBand and is also a summation. Our goal is to sort the Agency Revenue fields, located in GroupFooterBand2, in descending order. The first issue is that this data is not in the databand, therefore we cannot open up the properties and apply the general sort rule. The second issue is that the Agency Revenue field is not the result of one amount, it is generated based on a summation between other fields.
Are there any ideas you have as to how to accomplish our goal of grouping our dataset by the Customer Name and then sorting the Agency Revenue amounts in decending order? I have included screenshots of the design and preview for your reference. If needed, I can provide you with the .mrt file in question.
Thank you!
Ashley
