There is probably a very simple flag for this... I have a dataset that comes presorted, it has a column called IsFavorite. Imagine
true result1
true result2
false result3
true result4
false result5
When I group by IsFavorite and take the empty sort OR apply the ascending sort, I see (correctly)
IsFavorite: false
false result3
false result5
IsFavorite: true
true result1
true result2
true result4
However, if I apply the descending sort, the entire result set gets flipped upside down!
IsFavorite: true
true result4
true result2
true result1
IsFavorite: false
false result5
false result3
What I can do to preserve the original sort order when changing the group sort order? In this case I've used numerical results, but imagine how it looks when the results were alphabetically sorted originally!
Thank you in advance.
Respectfully,
Tim