I’m finding unexpected behavior when sorting on a single select data lookup field.
In the source table the HT Location is a single lookup field. I have the field values ordered in the “customize field type” control (note Dairy case in in blue before ...