Pivot Pivot Table

Hi there

I'm not sure if I overlooked something on how to pivot a pivot table properly. I've seen many Github tickets closed so I think this has been solved.

I have replicated it with the test data this simple query:

Now I have this pivot table visualisation:

And that's basically the data I want to see but as you probably can guess just rows and columns flipped. So having 2 rows: Count and Sum of Payment and the columns are just the months.

I don't seem to be able to configure it that way. When I move the date to columns, the table gets blank and I also can't move the measures to the rows.

Is that really not possible or am I missing something?


PS: I also tried to use the normal table option with its pivot functionality but doesn't work either with that.