Order more than one value by Index

[eduardosilvin3]

Hello all, I need to sort by index the "USD sub" but I find the problem that is shown there, any sugestion? 

[Ahmedx]

create a new column like this and you need to use it, it will be sorted automatically

[eduardosilvin3]

hey thank you, works great, just I did not mention I have a Matrix and is doing this, instead group them, all of them are in different rows... any idea? (graphs and tables work ok) 

[Ahmedx]

I didn’t understand you, what needs to be done in the matrix

[eduardosilvin3]

Sorry, the goal is this, grouped if they have the same name like this:

But that result I got it with a conditional column:

The problem with that conditional column is that sometimes the financial reports have a lot of concepts so will be very complicated do it one by one, so your response is great but the matrix is not responding as wanted

[Ahmedx · Accepted solution]

pls try this

[eduardosilvin3]

Thaaaank you so much, I was trying like 10000 things but with terrible results! 

Cheers!!!