Sorting Values in Matrix with multiple columns & values

[Anonymous]

Hello,

It seemed quite trivial but I do not manage to sort ascending/descending values in my matrix's columns

I have several financial KPIs, for each I have actual and budget values. I created a matrix as follows:

But I can't sort the values ascending/descending by just clicking either Actuals or Budget in the KPI I want

But if I take out "Financial Account" from columns, it works (but the values are obviously meaningless as it sums up several different KPI

Anything I am missing ? it seems to be a very simple thing...

Otherwise I though of creating a measure for each combination:

- Contract Margin Actuals

- Contract Margin Budget

- Sales Actuals

- Sales Budget

- ...

And put them in "Values" field in the Matrix, so as I can sort individually for each measure...

Any hint?

Thank you very much for your help,

TB

[amitchandak]

@Anonymous , Multi-column sorting is not there for matrix yet.