Forum Discussion

Yug's avatar
Yug
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...
Need Help
  • MFelix's avatar
    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.

     

     

Yug's avatar
Yug
Advocate I
2 years ago

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's avatar
MFelix
Super User
2 years ago

Yug

 

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. 

  • Yug's avatar
    Yug
    Advocate I
    2 years ago

    Thank you very much!