# New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Contributor II

## Accumulation in Pivot Table

Hello. My question on picture:

1 Solution

Accepted Solutions
Valued Contributor

## Re: Accumulation in Pivot Table

Try this with changing underlined values according to your requirement

If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month )  )

8 Replies
Esteemed Contributor

## Re: Accumulation in Pivot Table

if(dimensionality()=1, sum(Sales),

Contributor II

## Re: Accumulation in Pivot Table

thanks. but I need calculate month values also with accumulation

Valued Contributor

## Re: Accumulation in Pivot Table

What value you want to display at months.exactly??

Contributor II

## Re: Accumulation in Pivot Table

AcumSales

MonthDimDayDimSalesAcumSales
Apr77
1

1

1
223
347
May512
118
2210
3212
Esteemed Contributor

## Re: Accumulation in Pivot Table

Try this:

if(Dimensionality()=1,aggr(rangesum(Above(aggr(Sum(CA),Month),0,RowNo())),Month), rangesum(Above( Sum(CA),0,RowNo())))

Per analogy, I would have:

Valued Contributor

## Re: Accumulation in Pivot Table

Try this with changing underlined values according to your requirement

If(Dimensionality()=2,rangesum(above( sum(NormalValue), 0, rowno() )),aggr( rangesum(above( sum(NormalValue), 0, rowno() )),Month )  )

Contributor II

## Re: Accumulation in Pivot Table

Thanks!

Valued Contributor