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

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

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      One option is union and summarize

       

      union ( summarize( table[group_by1],table[group_by1],"measure","Sales","MTD",<MTD formula>, "YTD",<Ytd Formul>...),

      summarize( table[group_by1],table[group_by1],"measure","Cost","MTD",<MTD formula>, "YTD",<Ytd Formul>...)

      ...

       

      )

      Group, add constant value for measure name and MTD, QTD, YTD, last year etc.