Forum Discussion

Muthuramalingam's avatar
Muthuramalingam
Frequent Visitor
3 years ago
Solved

sort by column issue

Hi 

I am having financial accounts in one column and unique numbers in another column. I have sorted the financial accounts column by unique numbers column. we received the below error. We checked the numbers column, numbers are unique. Please suggest a way to solve the issue

 

 

  • The sort column must contain unique values which correspond to each unique value in the sorted column. So if you have two rows with value A, and the sort by column has 1 and then 2, you cannot sort by the sort column. 
    All "A" rows must have 1; all "B" rows must have 2 ... and so on

1 Reply

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion

    The sort column must contain unique values which correspond to each unique value in the sorted column. So if you have two rows with value A, and the sort by column has 1 and then 2, you cannot sort by the sort column. 
    All "A" rows must have 1; all "B" rows must have 2 ... and so on