Accumulate

[smilingjohn]

Hi Expetise

I have a table diplaying the accumulative earnings for each year for a striaght table .

How do i achive this accumalative in a pivot table . Can you experty please help me on this ?

Please find my attchment of the QVW .

Thanks in Advance

[madhu_r]

Hi,

Use this expression in pivot table : RangeSum(Above(Sum(Earnings),0,RowNo()))

[lironbaram]

hi 

per your table this expression will do the trick 

Rangesum(before(sum(Earnings),0,ColumnNo()))

but if the user will drag the year dimension to the left , the expression won't work 

so you need to make sure the user can't change the table structure

[sunny_talwar · Accepted solution]

You can use this

Aggr(RangeSum(Above(Sum(Earnings), 0, RowNo())), Year)

or this if you use QlikView 12 or above

Aggr(RangeSum(Above(Sum(Earnings), 0, RowNo())), (Year, (NUMERIC)))