stacking columns into rows

[Alex_Forsythe]

Hi, 

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? 

[IanT]

https://docs.looker.com/exploring-data/visualizing-query-results/table-next-options#transpose

[Dawid]

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