Dynamic columns from group by values?

Hi,

I must be missing something, I have a MetaBase report based on a query that returns the total sales for each of our customer per month (using a group by on invoice data). In that report, the total for each month appear in the final report as individual columns with the month's number. Those columns are "dynamic" in the sense that the list of months shown comes from the data present in the DB.

I'm trying to setup a new report with a very similar grouping just different filters etc, and two values per month, sales and hours worked. Everything works fine except that MetaBase shows a line per customer per month, and I can't figure out how to turn that into a column per month (or rather two since I have two values per month now).

What am I missing? I can't find the setting for this when editing the original report.

Thanks!

Hello there,

I think you are looking for a Pivot table visualization or a Table visualization with auto-pivoting.

Hi,

Thanks, what I had missed was the "Columns" section in the visualization tab of the pivot table feature. Works fine now.

Cheers