Hi all, has anyne found a way to configure a pivot table so the date field can be both columns and rows?
I have a lot of tables currently running on mysql queries but I’m trying to migrate these to Noloco pivot tables.
The mysql query display as below, you can see its the same datefield, just grouped by year in rows, and month in columns.
And this is how it looks using a noloco pivot:
I would reccomend breaking your date field into 2 new formula fields:
One which is year and another which is month
For month I would probably use the numeric month like 01 - Jan, 02 - Feb (for example)
The formula would just be TEXT({dateField}, "YYYY") and TEXT({dateField}, "MM - MMM")
Thanks @darragh , unfortunately my reports run across many (10+) date fields depending on what the end result should be, so not keen on creating 20 extra fields in the tables. Ill keep using the queries for now 
I see, well without transforming your data into that format, I don’t think there’s another option actually.
