I have a table like the “Attachment1”
Month Column: 1- 12
Accounts: 3 different accounts
Concept: Actual or Forecast
and I need to create from this table, another table like the attachment # 2. I am using to separate concepts the function “pivot where(select expression, expression)” and it worked, but when I try to pivot the fiscal month column it doesnt work anymore. Do you have any suggestions that could help!? 🙂 please?
Thank you experts!