Need help with expression

[#1]

I have to show the data in pivot table in my QlikView report as shown below

Period          Amount

-------------------------------------

4/1/2012          360

5/1/2012          1000

6/1/2012          1500

The actual amount values for period

5/1/2012 is 640 and for 6/1/2012 is 500.

To make it possible (ie. current period amount + previous period amount), I am using expression

=sum(Amount) + sum( {$<Period=$(vPrevMonth)>} Amount)

and vPrevMonth is calculated as addmonths(Period,-1)

Not sure my approach is right or not, but somehow the expression is not working. Please suugest the way to achieve this in QlikView.

Thanks.

[swuehl · Accepted solution]

Try using

=rangesum(above(sum(Amount),0,rowno() )

or if your period dimension is pivoted to the top:

=rangesum(before(sum(Amount),0,rowno() )

[#3]

Thanks swuehl