Rotate table in metabase

Execute me ,how to rotate table as(row changed to column):


Hi @dropsun
That’s called pivot. And yes, Metabase can do that, but currently only if you have 3 columns (one numeric, two groupings):
Otherwise you would need to do it in SQL - some databases has functions to pivot the result set.

Hi, Flamber :slight_smile: currently can I do that with more than 3 columns (one numeric, the rest groupings)?

@Helena More advanced Pivot Tables have been available since 0.38.0 (for some databases)

1 Like

I'm going to see this post. Thank u!