Columns to Rows for P&L Pivot

asantos — Tue, 28 Dec 2021 20:18:46 GMT

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!

Re: Columns to Rows for P&L Pivot

chrismarlow — Sat, 25 Jul 2020 13:23:32 GMT

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.

topic Columns to Rows for P&L Pivot in Connectivity & Data Prep

Columns to Rows for P&L Pivot

Re: Columns to Rows for P&L Pivot