subtracting 'cross horizontal' in pivot table?

[#1]

Hi Guys,

I have a similar pivot table below. On the first colum are 2 expressions all the headers repesent the dimension year

Expressions	2008	2009	2010	2011	2012
sum (investments)	180.000	178000	152.000	104.884	93.021
sum (investments) - (expenses)	170.000	168.000	148.000	100.000	90.000
Difference between next year?	2000	20.000	48.000	10.000	-

Now I would like to create an expression that does the following:

sum (investments) - (expenses) of 2008 - sum (investments) - (expenses) of 2009  (170.000 - 168.000) = 2000

sum (investments) - (expenses) of 2009 - sum (investments) - (expenses) of 2010  (168000 - 148000)=20.000

sum (investments) - (expenses) of 2010 - sum (investments) - (expenses) of 2011 (148000 - 100.000)=48.000

sum (investments) - (expenses) of 2011 - sum (investments) - (expenses) of 2012 (100.000 - 90.000)= 10.000

Is this possible within Qlikview?

Thanks in advance!

Carter.

[#2]

you dont need to do it by pivot table (try straight and horizontal view)

as for your question ... try function above()

your expression should look :

=sum(investments-expenses)-Below(sum(investments-expenses))

[#3 · Accepted solution]

i mean try function below()

[#4]

Many Thanks ! Below and straight table using horizontal view, did the job!

Carter