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%-60% & <25%)

 

Q2. I need to display the column in this order Q1, Q2, Q3, Q4, Q1_WK_01, Q1_WK,02.....Q1_WK13, Q2_WK_01....

 

Is there a way of doing this?

 

Thank you 

 

Regards,

Sandeep

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

     

     

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Cool,

     

    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.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      AnonymousPavelR

       

      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
        Icon for Solution Specialist rankSolution 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

         

         

  • 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

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

       

      Issue Resolved.

       

      Thanks you guys for your support , resolution & time.

       

      Regards,

      Sandeep