1 Reply Latest reply: Sep 20, 2011 3:39 AM by William Riley RSS

    How to find difference between two row values

      I have data like In columns  2009         2010          2011

      In rows  Budget Allocated   30000       40000        50000

      Amount spent                    26000        46000       70000

       

       

      i need Out put  Like

      I have data like In columns  2009        %change      2010    % change        2011   %change

      In rows  Budget Allocated   30000              -          40000           5%         50000    10%

      Amount spent                    26000              -          46000           10%       70000     25%

       

      i need to find out %change between two year 2010 -2009in budget allocation and %change in amount spent Y-Y

       

       

      Please help me

       

      Regards,

      Bala prasad