Pivot merged table

Hello,

I am currently trying to pivot a dimension column in a table which was resulted by 3 queries. However I get this message:

Is there any way I can get around this error and pivot a column? Or do I have to edit the tables on the “Develop” tab?

Thanks in advance,

Regis Oscar Land.