10 Replies Latest reply: Oct 30, 2014 4:27 PM by Ama Domevscek RSS

    Calculate Difference column

      Hello,

       

      Next example

      First column year with totals pro week for years 2014 and 2013

       

      2014                       2013

      52 100                    150

      51 200                     200

      50 300                    600

      49 400                    350

       

      Now i want to add 2 columns pro year.

      First column shows me the difference amount. Column next to it shows me the percentage growth / lost toward previous year.

       

      2014                                  2013

      52 100   -50     33,33%        150

      51 200   +0            0%        200

      50 300   -300         -50%      600

      49 400   +50          14%       350

       

      How to do this?