Custom Sort of New Colum

[utsavlexmark]

In my table I have created one colum for "Rang".

If rank is >=1 and <=10 , "Position 1-10",

and so on

Now I wanted to sort the column as

if "Position 1-10" it will come first

if "Position 11-20" it will come next

and so on

What could be the solution for this?

Regards

Utsav 

[v-xiaotang]

Hi @utsavlexmark 

Thanks for reaching out to us.

>> I have created one colum for "Rang". Now I wanted to sort the column as   if "Position 1-10" it will come first  if "Position 11-20" it will come next

-

if "Position 11-20" it will come next, then what is in front of it?

Could you share some sample data and its expected output? thanks

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[PabloDeheza]

Hi there!

A solution could be adding another column, lets say RankOrder, where for "Position 1-10" the value is 1, for "Position 11-20" the value is 2 and so on. Once that column is created, you select Rank and got to Column Tools -> Sort by another column and select Rank Order.

Let me know if that helps!

[amitchandak]

@utsavlexmark , Also Create a sort column

Switch( True() ,

[Rank] <=10 ,1 ,

[Rank] <=20 ,2 ,

//add others

100

)

and use it as sort column for your column Rang

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c