You could manually sort the filter. From Tableau help:
- From the Data pane (where the Dimensions and Measures are displayed) right-click the field that you want to format, and then select Default Properties > Sort.
- Select Manual, adjust the sort order, and then click OK.
That might break down when new rows arrive...
Thank you, Ray. You are right - the manual sort would be a temporary fix, but this sheet is refreshed every day in desktop then uploaded to a server, so when new rows arrive manually sorting daily wouldn't be sustainable.
Any other ideas or solutions?