I have created a points table for a race event and would like to sort the results in a specific order.
I am working with a table view that contains 3 sort criteria:
- the race event (working fine done via table settings)
- class of a car A, B , C and
- the points each driver receives.
I would like the order to be A then points B then points C then points regardless of what class has the highest points.
If for example a C class car has points higher than any B class car then the stacking order is ACB. As soon as any B class car gets higher points than the C class car then the order is ABC (how I would like it). This can be seen in class A where Driver 2 has the lowest points of all.
I have tried re arranging the sort order but that does nothing.