1 Reply Latest reply: May 11, 2012 8:15 AM by Dan-Ketil Jakobsen RSS

    Show difference month by month

    Dan-Ketil Jakobsen

      Hi

       

      I have a table that I want to look like this

       

                          Area 1                           Area 2

                     Value     Change                Value     Change

      201201     10          0                         22          0

      201202     18          8                         20          -2

      201203      25         7                         24          4

      ..

       

      My problem is the Change column. I nned it to show the cahnge form an period to the next

      I found one forumla, but that adds the changes

       

      =rangesum(above(column(1),1,(RowNo()-1)))//+ column(1)

       

      How can I get the Change column to simply show the difference between from one period to another?

       

      BR

      Dan