Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Sorting Values in Matrix with multiple columns & values

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

1 Reply