Date gets an empty header row if also split to columns
I have a query for Google Analytics that is Split to Rows: "Year & Month" and Split to Columns: "Campaign".
I need the data in Google Data Studio but the problem is that Google doesn't give me the first column as a dimension because using both Split to Rows and Split to Columns makes it so the first cell is empty (instead of containing "Month" as I expected).
I need the header row to update with future queries because the names of the Campaigns can change. How do I get "Month" into the first cell so that Google Data Studio will allow me to use that column as a date dimension?
1 person has this problem