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

     

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

BaskarPavelR

 

I created a new colum and tried sorting my original column based on this new column.I get the below error

 

 

I have created the original column based on the below formula.Is that creating problems?

 

Thanks for your time.

 

 

 

Regards,

Sandeep

 

 

 

PavelR's avatar
PavelR
Solution Specialist
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

 

 

  • ngkrich's avatar
    ngkrich
    Regular Visitor
    9 years ago

    PavelR

     

    Pavel, I am having trouble doing this as you described. Any help would be greatly appreciated. I created another table with the same Names for my lookup, with the sort order. Then created a relationship between that Names and my original Table Names. Howver, the option to sort by the order I created is sitll not in the sort list. Am I doing something wrong?

    • PavelR's avatar
      PavelR
      Solution Specialist
      9 years ago

      Hi ngkrich, just choose your Name column in Fields pane

      In Modeling pane click on Sort a Sort by column with sorting order.

      That is it. Regards

      Pavel