0 Replies Latest reply: Nov 22, 2012 5:37 PM by steve peroni RSS

    percentage calculation

    steve peroni

      Dear all,

      I'm coping a big problem, for me of course, but I'm not able to go on

      I have the following tables:

       

      Details

      Year     Month     Area    GLaccount     Value   

      2012     01            xy         1              150000

      2012     01            xy          2               50000

      2012     02            xy          3              150000

      2012     02            aa          1               50000           

      2012     02            aa          2               40000  

      ...

       

      Purchase

      Year     Month     Area          Total Purchase

      2012          01     xy              250000

      2012          02     xy              100000

      2012          02     aa              100000

       

       

      I need to produce the following pivot for 2012

       

                     GlAccount   Value           

      AREA     TOTALpurchase               1         %                2           %                 3            %

      xy               350000                  150000    42,85           50000     14,30          150000     42,85      

      aa               90000                      50000   55,55            40000     44,45       

       

                                                            

       

      The percentage values, are calculated as  GLaccount_Value_for area/Total purchase for area

       

      I don't know how to solve it.

      Help please

       

      Thanks in advance