Question

stacking columns into rows

  • 2 March 2021
  • 2 replies
  • 1313 views

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? 


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
Badge

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