Forum Discussion

Advocate I

2 years ago

Solved

Create hierarchy table based on columns from table A to create a PnL table

I have a table where my PnL elements are all stored as columns as in below table "Table A". And I would like to create a hierarchy table connected to this table so that I can create a voyage pnl visu...

MFelix
2 years ago
Hi Yug ,

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 User

2 years ago

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.

Advocate I

2 years ago

Thank you very much!