Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Custom Sort by Row in Matrix Table

Hello, I'm trying to custom sort by multiple rows in a matrix table. I have tried adding a switch formula to the dataset and then sorting by that column however it does not work. The only time it wor...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous 

    Please correct me if I wrongly understood your question.

    You want sort Sales Team by the sort column without putting the sort column in matrix . But the operation is not feasible, because the visual has no conditions to judge how to sort the Sales Team if the column isn’t in Matrix.

    So you should put the sort column in Matrix then you can sort the column to effect the Sales Team .

    Best Regards

    Community Support Team _ Ailsa Tao

     

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

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
5 years ago

Did you try that 'Sort by column' on your [Sort] column?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Yes I did but unfortunately it doesn't work

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      This is what I'm going for but without showing the sort in matrix

       

       

    • ChrisMendoza's avatar
      ChrisMendoza
      Resident Rockstar
      5 years ago

      Try creating a table with DISTINCT() [Sales Team] where you define the sort then use that [Sales Team] column in your visual after you make the relationship. On that table run the 'Sort by Column'.

       

      SortOrder Distinct Sales Team
      1 West
      2 Central
      3 East
      ... ...