Skip to Content
0
Former Member
Mar 03, 2009 at 05:25 PM

Is it possible to do sorting on multiple field inside a GROUP

1571 Views

Hi

I am wondering if it is possible to do a multiple sorting on multiple column/fields?

When I right click on Change Group on the report

on the "Change Group Options" window, it only has one field which allow you to sort in ascending/ descending order.

I notice that it also has another checkbox which called Use a formula as Group Sort order, I am not quite sure how to use it to sort multifield/column.

E.g.

I have a table which has 5 fields

I would like to sort it by TotalSpend, TotalEarned, Department, ...etc

I would be grateful, if you can show me how to do a group sorting for multi column/fields

Thanks in advance.