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.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Chris, I did try that and received the error below

 

ChrisMendoza's avatar
ChrisMendoza
Resident Rockstar
5 years ago

Anonymous - hard to tell without knowing your model. This may sound strange but there was a time when I had a similar error and the only difference in correcting was the direction[field] started from to the [field] ending. Basically I got the error when I pulled from Table1[ColumnB] to Table2[ColumnA] but then I tried Table2[ColumnA] to Table1[ColumnB] and it worked.