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

     

     

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

 

As PaveIr mentioned, the thread to customsize sort matrix rows and column is dding Sort column (values 1, 2, 3 etc.) to your dimensions, and change the default sort column (itself) to Sort Column under "Sort by column". 

 

The error message means you can't sort by a column that depends on the column you want sorted. To work around this issue, please create the Sort Column in Query Editor. Go to Edit Queries, under the Add Column tab, select Conditional Column. You can use this method to create both columns [Lable] and [Sort Column].

 

 

For more details, please refer to KGrice's reply in this link: Sort by another column error

 

Thanks,
Yuliana Gu

Anonymous's avatar
Anonymous
Not applicable
9 years ago

v-yulgu-msftPavelRBaskar

 

Issue Resolved.

 

Thanks you guys for your support , resolution & time.

 

Regards,

Sandeep