stacking columns into rows

  • 2 March 2021
  • 2 replies


I’m trying to figure out how to have my a new measure shown as a new row instead of a new column in a look? For example I was gross revenue than a new row that shows cost of goods sold, than calculate gross profit, with each being a new row in the data table. Is there anyway I can do this? 

This topic has been closed for comments

2 replies

Userlevel 7
Badge +1

One thing to note is that transposition does not honour the order of columns if you mix table calculations with measures; table calculations will always be at the end : (

Userlevel 6