Having more than one member of GroupField with opposite SortOrder displays the wrong order when previewed.
0_GroupField = Priority Descending
1_GroupField = ProjectID Ascending
Displays both in ascending order.
To reproduce the problem please follow the steps below:
When you preview the results, both groups are displayed in ascending order.
Waiting for fix in a future release of Toad For Data Analysts