Hello there !
To give a bit of context:
I would like to reuse output of a pivot table, so that I can perform new operations on it.
–> My pivot table using the UI is outputting:
I have found this:
Pivot the result of a SQL query ,
telling me that I cannot do it with the UI, but need to use corosstab function in my SQL query (I’m using Postgre)
So I’ve designed this query:
But I looks like the cross tab function is not being recognised :
Look here how the query that is supposed to be passed as text inside is not recognised as such :
And I get a syntax error:
ERROR: syntax error at or near “‘year’” Position: 701
Thanks for you help