I think you can do that by creating three different ranks.
Don't use Rank_unique but normal "Rank"
Rank(SUM([Trial B Enrolled/Randomized]))
RANK(SUM([Trial B Completed Screening Visits]))
RANK(SUM([Trial B Eligible to Screen]))
Trials_sorting_SM_9.3.twbx 63.6 KB
Thank you, Shin! Worked perfectly!
You are welcome.