Subtable sorting and grouping
I set up a sort on my subtable that is essentially: Field A, Field B, Field C (ascending). I then set up a group on Field B. My table now sorts by Field B (grouped), Field C and seemingly ignores Field A as items which have a lower value in Field A show up after items with a higher value in Field A.
Is there anything I can do to fix this so Field A remains my primary sort but I group the records based on value in Field B?