Roll up Table from Tabular form to Pivot using DAX or Matrix

[sandeepk66]

Hi Power Geeks,

I need a Pivot table based on the above Tabular form to roll up on Levels for each PRICECALCID

Basically LEVEL 0 is the sum of Level 1 and Packaging cost per unit is the sum of cost prices od Descriptions BOM,Process,Surcharge.

And 

Here is the 1st tables looks like:

 

Please help in generating a  pivot table report and linking 1st table to this new pivot table

[v-chuncz-msft]

@sandeepk66,

Basically, you will use the Matrix visual, but might need to create a calculated table first.

[sandeepk66]

How to  create a calculated table first to achiebe this is MAtrix, Can you show up a Mockup?

[v-chuncz-msft]

@sandeepk66,

The sample data in picture above is not very precise. Share us an accurate simplified model.