@Narayan Raum @Doug Williams Thank you for your suggestions and help. Ultimately, we went with the solution of custom calculated field and hidden sort dependency. 1) Custom field creation of ConditionSort IF(Condition="ON","3-On Target",(IF(Condition="AR","2-At Risk",(IF(Condition="IT","1-In Trouble","Blank"))))) 2) Add custom field to report, sort, apply dependency sort code in text mode to original Condition field.
querysort=DE:ConditionSort
sortType=asc
sortOrder=2
3) Remove custom field from report 4) "Recalculate custom expressions" for all preexisting projects
David Ngo JLL