group by one field, but sort by another field

[snoopyyu]

Hi,

I have three fields in the my table:
Client
Fees
Costs

In my report, I am presenting the sum(fees), sum(costs) and sum(fees) + sum(costs) for each "Client".
So, when create the report, I group by "Client".

If I want to present this data sorted by sum(fees) + sum(costs) in descending order, how can I do this?

Thanks in advance.

Snoopy

 

[bdreed35]

You probably want to use the TOP N functionality.

Create a formula that adds your cost field and fees field together (not the sums).
Create a summary of this formula for yor client grouping.
Use the Top N expert and pick the sum of the formula and pick descending.

~Brian