a Name column code below:@Trim(@Name([Abbreviate]; DisplayName)) +" “+ (@If(JobTitle!=”“;JobTitle + " “;””) + @If(AltName=@True;" (“+@Name([Abbreviate];AltFullName)+”)“;”"))
I want someone have jobtitle should sort higher than don’t have jobtitle.The column properties default sort way could not satisfy this.
the jobtitle has 2 values,deputy sector chief and sector chief.I hope sector chief on the top and deputy follow.
it show like this:
Ainsley Moses sector chief
Meredith Booth deputy sector chief
Amal Wolfe
Cedric Castaneda
Felix Harmon
Leigh Vazquez
how to make this?not only sort by Ascending or descending,thanks for every feedback.
Li wit