Can we do this in Metabase–
I have a metabase instance running …
I have a table by name payment, which has close to 50 fields and 5000 rows. The fields of interest here are revenue_type, amount, created_at (this is in dd/mm/yyyy format). The query should group the distinct revenue_type in first column and months ( first row and not dates). Now the intersection between this column and row should tell the amount. So the pivot will tell which revenue type has earned what amount in different months.
This was a click job in olap databases.