Forum Discussion

JimmyCeron_PBI1's avatar
JimmyCeron_PBI1
Frequent Visitor
5 years ago
Solved

Custom Sort on a Matrix Help Pleaseeee!!!!!!

After having tried so many different things and failing, I decided to reach out to this incredible community. I have a Matrix that need to be displayed in a specifc sort. I know how I can accomplish...
Need Help
  • JimmyCeron_PBI1's avatar
    JimmyCeron_PBI1
    5 years ago

    Of course!!! I created Index colum after unpivotting other  columns; that create an idex for every single record. So i went back to PQ and created index then unpivot columns, and that worked as expected.

     

    Thank you so muchhhhhh!

Wimverh's avatar
Wimverh
Resolver IV
5 years ago

You need to create an index column, just on the field Descripton-Owner
401 Kathy => 1
401 - Credit Kathy => 2

then add a custom sort to your column on the new index

 

then sort in the matrix on the description column