Use of before or after function

[Anonymous]

Hi

I have a pivot table looking like this:

Area	201206	201205	201204
North	93,4	95,2	94,7
South	92,9	95,1	94,9
East	93,1	93,9	94,5

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

Area1	2012062		201205		201204
	index	diff	index	diff	index
North	93,4	- 1,8	95,2	0,5	94,7
South	92,9	- 2,2	95,1	0,2	94,9
East	93,1	-0,8	93,9	-0,6	94,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

[Miguel_Angel_Baeyens · Accepted solution]

Hi Dan,

The diff expression should be

[index] - After([index])

Using [index] to refer to the name of the expression.

Hope that helps.

Miguel

[Anonymous]

Hi Miguel

Simplicity.

Solves my problem.

Thanks!

BR

Dan