Discussion board where members can get started with QlikView.
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
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)))
View solution in original post
Use this expression in pivot table : RangeSum(Above(Sum(Earnings),0,RowNo()))
per your table this expression will do the trick
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