Forum Discussion

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
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

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

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
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