Forum Discussion

Yug's avatar
Yug
Icon for Advocate I rankAdvocate 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.

     

     

MFelix's avatar
MFelix
Icon for Super User rankSuper User
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
Icon for Advocate I rankAdvocate 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
    Icon for Super User rankSuper 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
      Icon for Advocate I rankAdvocate I
      2 years ago

      Thank you very much!