Pivot Table - Adding Previous Column Values

[Anonymous]

Helo,

I have this data

Name	Value
Initial	3309.46
Att1	4
Att2	-2
Att3	10
Final	12

I am trying to create a table that looks like this

	Initial	Att1	Att2	Att3	Final
Start	3309.46				3321.46
Up +		4	-	10
Down -		-	2	-
Change		3313.46	3311.46	3321.46

I could get "Start", "Up" and "Down" in qlikview using a pivot table. Couldnt get "Change" yet.

How do I get access to previous column values? I tried using before and above but still couldnt get the result.

Attached sample

[sunny_talwar · Accepted solution]

May be try this:

if(match(Name, 'Initial', 'Final'), '', RangeSum(Before(Sum(Value), 0, ColumnNo())))

[swuehl]

For Change, try

if(match(Name, 'Initial', 'Final'), '', Rangesum(before(sum(Value),0,ColumnNo())))