Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Sorting a Matrix by 2 values

I have a matrix that resembles the following:

 

Year, Country, Value

2019 UK          100

2019 France    200

2019 Germany 300

2020 UK           200

2020 France     100

2020 Germany 300

 

And I want it ordered by Year, Value

2019   Germany   300

2019   France       200

2019   UK             100

2020   Germany    300

2020   UK              200

2020   France        100

 

Currently I have the option to sort by Year only or Value only. 

Is there a way to replicate the SQL Group by Year, Value?

 

Thanks.