Pivot Table > Present Measures as rows in pivot table

Hello guys!

So, to keep it nice and short… I have a bunch of measures which I want to all put into one pivot table in such a way that each measure will sit on it’s own row while columns will represent a dimension splitting those rows into columns.

Currently if I drop a few measures into one pivot they will all be represented as columns instead of rows.

Wonder if there is any workaround?

Would you be able to draw out what you mean for easier interpretation?

It looks like what you’re looking for is something like metrics sheets, except that instead of date/time, you want to have your own custom dimesion (country, category, etc)?

Hello Huy Nguyen!

Yes, this is pretty much exactly what I mean. So, transposed pivot table (which is what your metrics sheet is in essence) but with ability to split not only by date but also by other dimension in my dataset

Not sure if it is possible with available charts?

1 Like

Hi Dmitry,

Welcome to the community!

Unfortunately, right now the Metric Sheet and the Pivot table are the closest to your expectation.
I’m curious: is there any specific reason why you would like to transpose the pivot table instead of the same format?