Hey I'm trying to make an custom sort that i can use in my reports to where i can sort each stage in this specific order.(Incubation,Implementation,Pre implimentation). I need to create this sorting type so that i can sort in different way instead of alphabetical order. Could someone give me guidance on how to implement this.
***Edited by Moderator Marissa to update platform capability tags****
The only way I can think of to do this is to populate a hidden column using a Function Alias that returns values that will sort the way you want them (e.g., Incubation = 1, Implementation = 2, etc). The problem is, you can provide the initial report sorted the way you want, but if it gets re-sorted on another column, you can't get back to the original sort.