Custom Column Sorting

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****


Keep up to date on this post and subscribe to comments

August 16, 2019 - 11:53am

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.