Lakshay
Databricks Employee
Databricks Employee

‎03-15-2023 09:53 AM

Hi @Oscar Dyremyhr​ , PIVOT doesn't support two FOR clauses. You can PIVOT either on month or on quarter.

https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-pivot.html