Forum Discussion

sandeepk66's avatar
sandeepk66
Icon for Advocate I rankAdvocate I
9 years ago

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

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

3 Replies

    • sandeepk66's avatar
      sandeepk66
      Icon for Advocate I rankAdvocate I

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

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Icon for Community Support rankCommunity Support

        sandeepk66,

         

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