Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Transpose measures in visual table

Hello everyone, still trying to figure out how to transpose columns to rows. Idea: i want to make months on the top of the table and then Measures to the left. Bendros pajamos....., EUR and bendros pajamos...., metrais are measures. 

 

Is it some how possible?

 

 

  • amitchandak's avatar
    amitchandak
    4 years ago

    Anonymous , You have the option "Switch values to row" in new format pane and show on row in old format pane

     

    Or refer

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

2 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , You have the option "Switch values to row" in new format pane and show on row in old format pane

     

    Or refer

    Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thank you very much Amitchandak. Problem was that i from the beggining added rows, and this is why i wasnt able to switch values to rows. But after i deleted it and added after change, everything works fine. 

       

      THANK YOU ONCE AGAIN.