2 Replies Latest reply: Jun 8, 2012 6:35 AM by Dan-Ketil Jakobsen RSS

    Use of before or after function

    Dan-Ketil Jakobsen

      Hi

       

      I have a pivot table looking like this:

      Area201206 201205201204
      North93,495,294,7
      South92,995,194,9
      East93,193,994,5

       

      I now need to add a collumn for each period where I calculate the differense in Index form last period

       

      Area12012062 201205 201204

      indexdiffindexdiffindex
      North93,4- 1,895,20,594,7
      South92,9- 2,295,10,294,9
      East93,1-0,893,9-0,694,5






       

      I tried this

      =Rangesum(before(column(1),0,(RowNo()+1)))

      But this one accumulates values. Tried to alter different parts of it, bus since I do not fully understand what is going on in this formula, I`m just guessing. Wit no luck so far.

       

      Any ideas?

       

      BR

      Dan