Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

arrange matrix rows and column

HI,   I have created a matrix.below screenshot is the matrix i have created.i have 2 questions associated with it.     Q1. The row lable i need it in this order(>80%, 70%-80%, 60%-70%, 50%...
Need Help
  • PavelR's avatar
    PavelR
    9 years ago

    Anonymous Just create dimension with those labels and column which wil determine the sort order (values 1, 2, 3 etc.). Create relationship between dimension and facts, if it is not active yet, and you're done :smileywink:

     

    Regards.

    Pavel

     

     

PavelR's avatar
PavelR
Icon for Solution Specialist rankSolution Specialist
9 years ago

Hi Anonymous

 

I would recommend adding Sort column (values 1, 2, 3 etc.) to your dimensions, and on the relevant columns just use "Sort by column" and add you Sort column.

 

Regards.

Pavel