# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Contributor III

## Accumulate

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 .

1 Solution

Accepted Solutions
MVP

## Re: Accumulate

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)))``
3 Replies
New Contributor II

## Re: Accumulate

Hi,

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

Partner

## Re: Accumulate

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

MVP

## Re: Accumulate

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)))``