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...
Thank you very much for your help,