Accumulation in Pivot Table

[evgeniystuchalk]

Hello. My question on picture:

[OmarBenSalem]

change your expression as follow:

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

if(dimensionality()=2, your expression))

[evgeniystuchalk]

thanks. but I need calculate month values also with accumulation

[Anonymous]

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

[evgeniystuchalk]

AcumSales

MonthDim	DayDim	Sales	AcumSales
Apr		7	7
	1	1	1
	2	2	3
	3	4	7
May		5	12
	1	1	8
	2	2	10
	3	2	12

[OmarBenSalem]

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:

[Anonymous · Accepted solution]

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

[evgeniystuchalk]

Thanks!

[Anonymous]

Glad it helped you