Forum Discussion
Create hierarchy table based on columns from table A to create a PnL table
Hi Anonymous ,
For this you need to unpivot your data and remove the Voyage and Cargo result values (since they are totals) the final resul will look like this:
Then you can do the relationship and measure to calculate correctly.
Super UserHi Anonymous ,
For this you need to unpivot your data and remove the Voyage and Cargo result values (since they are totals) the final resul will look like this:
Then you can do the relationship and measure to calculate correctly.
Thank you MFelix for your reply.
My thought was to do somewhat similar - create another unpovited table. However, since my data table which needs unpivoting is large, (200 columns and many thousand rows and increasing), do yow know if unpivoting will have any impact the performance of the report?
- MFelix
Anonymous
The impact that yyou may have is on refresh performance but this also depends on the quantity of rows you may be having on your model.
Thank you very much!