Columns to Rows for P&L Pivot

[asantos]

Hello!

My question has been asked, but the solutions don't answer all of my questions, given the situation here.

The dataset is as follows:

This is how the P&L Pivot should look like:

Basically, the column headers would be now row headers, some of which will have to be calculated measures.

Could you point me to the right direction?

Thank you!

[chrismarlow]

Hi,

If you don't have the option of scripting to change you data model an option that may start to get you close to the output you want is using ValueList in a calculated dimension & then Pick/Match in expression, similar to the attached.

Cheers,

Chris.