Advanced sort on hyperlink column is incorrect
I have a column and sorted by advanced custom order. In result i got the correct result, if i add hyperlink to that column then sort option changed to default ascending order.
How to retain the custom order even though hyperlink is applied. I tried added one more column beside then sorted and hide it but still if i apply hyperlink again it is changed to ascending order.