group by id then sort by sum of values

[rrmcguire]

Hello,

I have a report with a bunch of records which are group by the main user of those records, then the values of the "revenue" field is sumarized for each user and a grand total

Question is the report is group by the user, but I need it to be sorted descending by the sum calculated for each users revenue.

Is this possible?

 

[lbass]

If revenue is based on a simple inserted summary, you can go to report->group sort and select the summary as your group sort field. If not, please post the formula used for revenue.

-LB

 

[rrmcguire]

revenue=total charges - fsc


then in the group footer(grouped by user id) is a summary field which sums the value for each record based on that user id.

currently the report is grouped by user id for all the user id's records, then the revenue is totaled in the summary for the group

What I need the report to do is sort descending by those summary totals

 

[rrmcguire]

got it figured out through the group sort expert...thanks