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?


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?


I have the same request. The reason I want it is that we’re displaying accounting data by region. I would like the regions to be the columns and the revenue, cost, net revenue etc as rows as that’s much easier to read.

1 Like

Hi @dmitry_sofiev and @andrea
I have the same request with u. Especially when I work with a table having 5-6 columns but just one row only, I’d like to swap its columns and row to make the table easier to read.

I’ve created a feature request here: Ability to transpose columns to rows (or vice versa) in table/pivot table. Feel free to share your case and upvote this topic :blush:

1 Like