Sort column based on 2 columns

[Anonymous]

I have a requirement where I have to sort the column based on 2 columns, so when ever the column is used to visualize it will be sorted.

So the problem is when i tried to sort the column value based on Sort, I am getting an error saying "There cant be more than one sortID for value". but when I check the data after adding the id filter i am getting the correct sorting for value. 

Value              SortID  ID
Determine Fix 3         5257
Determine Fix 3         8062
Determine Fix 4         253
Determine Fix 6         106
Determine Fix 6         146
so is there any trick that i can apply when showing the data in a visual applying id filter so that i can get the correct sorting order.

[Anonymous]

Hi @Anonymous 

The reason you're encountering this error is that there cannot be more than one "sortID" for the same "value." The "sortID" should be a unique identifier and cannot be used multiple times for the same "value." You need to ensure that each "value" has a distinct "sortID" assigned to it. Review your data and fix the duplicate "sortID" values for the same "value" by selecting one and modifying the others accordingly.

Best regards,

Ezgi Naz Aslankara

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