Comments
-
@user03552 Please use beast mode calculation as below: Rank_Order: CASE WHEN field = 'A' THEN 1 WHEN field = 'B' THEN 2 WHEN field = 'C' THEN 3 WHEN field = 'D' THEN 4 WHEN field = 'F' THEN 5 END Use this beast mode calculation in sorting(ascending). Hope this helps!
-
Thank you @amehdad for the explanation and clarification. Eventually, my requirement won't be fulfilled with quantiles as it divides regions in the equal proportion. However, I need regions with different proportions. :(