I have a list field (category) associated with content type
Fruit|Good Fruit Meal|Fantastic meal Thai Coffee|Coffee
In views, I used sorting as category ascending. Now, I expected result to be sorted as: Coffee, Fantastic meal and Good Fruit. BUT it is sorting using value of list item as: Fruit, Meal and Thai Coffee.
Is there any way I can sort it using list item text but nownot with list item value?
Thank you.