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.