I'm new here and I was wondering how to sort a column with my own custom sorting. For example, one of my columns in the table is Greek Class Column (Alpha, Beta, Gamma, etc as entries.). When the user clicks sort by class, it should sort the column according to the greek alphabet and not to the English alphabet. Alpha Beta Gamma Delta instead of Alpha Beta Delta Gamma. Is there a way to have my own custom sort?
I also put in a hidden column with the class order and associated each class with an integer value but don't know where to go from there. I've searched a lot but can't seem to find it.
Any help would be appreciated. Thanks!