Discussion board where members can learn more about Qlik Sense Data Connectivity.
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?
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.