Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

measures on rows matrix

Hi, 

 

Is it possible to have measures on rows in a matrix? 

I know there is an option in format-values and turn on "show on rows"

But what I further want to achieve is for example:
            this month    last year   TYD TYD-1
sales
cost
result

 

Sales Cost and results are all measures..

Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    I was assuming that those were columns on your data, can you please a sample share, as amitchandak  you need to make a use between switch function and an auxiliary table.

     

    Regards,

    MFelix

6 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    There is property "show on row".  that can help.

     

    But what you are writing splitting meaures into both row and column

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes, splitting measures into both row and column.

       

      Possible workaround would be creating a table with measures names and then using switch.

      I was hoping there is another quick way.

  • MFelix's avatar
    MFelix
    Super User
    6 years ago

    Hi Anonymous ,

     

    On the Matrix option find the option SHOW ON ROWS if you activate that, the measure will be shown as you need.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Tnx, I only get one column with the measures.

       

      I need  columns for example: last year, TYD and TYD-1

      • MFelix's avatar
        MFelix
        Super User
        6 years ago

        Hi Anonymous ,

         

        I was assuming that those were columns on your data, can you please a sample share, as amitchandak  you need to make a use between switch function and an auxiliary table.

         

        Regards,

        MFelix