Forum Discussion

viniciusosousa's avatar
viniciusosousa
Regular Visitor
5 years ago
Solved

Strange error with "Sort by Column"

Hi guys. I'm trying to sort one column by another using the "Sort by Column" feature in the Data Section. I created an "ORDEM" column that has no repeated values (guaranteed by Row_number () Over c...
  • OwenAuger's avatar
    5 years ago

    Hi viniciusosousa 

     

    The column to be used as the "sort by column" must contain at most one distinct value for each value in the column to be sorted.

    To make this work, you would need to set up ORDEM so that it (for example) contains 1 for MERCADO = 'BR', 2 for MERCADO = 'other value' and so on.

     

    Regards

    Owen