Forum Discussion
arrange matrix rows and column
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
Resident RockstarCool,
For this u have to create two column, for shorting order
example :
column = switch ( column_name,
">80%", 1,
">90%", 2,
.... etc
)
using this column u short the original dimension column.
try this , let know if any help.
PavelRSolution Specialist
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
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?
