4 Replies Latest reply: Jun 24, 2014 4:08 AM by Suvi Ahlstedt

# Accumulation in Pivot table (no acculation over year)

Hi all,

I have Pivot table with horizontal dimensions Year & Month and I´d like to calculate accumulated sums. Actually I did succeed with calculation but the problem is how "end" accumulation to yearend (for example Dec-2013)? In other words, when year changes, accumulation should start from Jan-2014, not continue from Dec-2013?

My Expression:

RangeSum(Before(TOTAL sum({<Month={\$(=vMinMonth)},CashPeriod={1},CashCalcMark={1} >}CashFlowAmount),0, ColumnNo(TOTAL)))+

RangeSum(Before(TOTAL sum({<Month={\$(=vMinMonth)},CashPeriod={1},CashCalcMark={2} >}CashFlowAmount*-1),0, ColumnNo(TOTAL)))+

RangeSum(Before(TOTAL sum({<CashPeriod={2},CashCalcMark={1} >}CashFlowAmount),0, ColumnNo(TOTAL)))+

RangeSum(Before(TOTAL sum({<CashPeriod={2},CashCalcMark={2} >}CashFlowAmount*-1),0, ColumnNo(TOTAL)))

Regards,

Suvi

Hi

chris

• ###### Re: Accumulation in Pivot table (no acculation over year)

Can you share your qvw? It will be easier to answer then.

• ###### Re: Re: Accumulation in Pivot table (no acculation over year)

Hi,

Here is example QVW, sorry for some lines are in Finnish.

Adding a year to expression did not change the results.

• ###### Re: Accumulation in Pivot table (no acculation over year)

Hi, I still have this over year accumulation problem, can someone help me?