Hi guys, I've a case where I'm grouping with the grid, but want to sort in a different order.
E.g. by default if my group data field has values A, B, C, D this would be the group order.
I have data that is sorted by sections of data, that have an order the client wants displayed in a priority order.
To simplify it something like:
Display Field Value Sort Field Value
A 2
B 4
C 1
D 3
I want the grouping text to be A, B, C, D, but the order to be C, A, D, B as per the sort field value (a field not to be visible).
I haven't been able to find anyway to do this. Any help greatly appreciated.