stacking columns into rows

Looker Q&A Looker
,
1

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?

2

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

1 Like
3

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