Thanks so much for the feedback. Your assumption is correct. I’m doing scenario 1 and it doesn’t seem to be working, yet scenario 4 does.
Here is a screenshot of my Data source:
Here is the table after the above sort has been applied. I’ve blurred most if it, but you can see the Customer is not sorted in alphabetical order:
However, on the front end, if I sort by company name, it works:
I can’t work out why one is working, but not the other.