Cant get desired results for multiple sort criteria in a view 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.

Problem:

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.
Can i suggest removing the grouping and getting the single table to display as you would like it and then once you have done that apply the grouping. It sounds as if youre sorting by points not by car class - can you change the sort to car class then add the group.

Or group by event and then sort by car class and points.