Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
may be you can add year={year} in your expression
chris
Can you share your qvw? It will be easier to answer then.
Hi,
Here is example QVW, sorry for some lines are in Finnish.
Adding a year to expression did not change the results.
Hi, I still have this over year accumulation problem, can someone help me?