Cumulative Calculation By each Row

[#1]

Greetings,

I would like to achieve cumulative calculation using pivot table.

Please find attach example(Spread Sheet) and sample model.

[#2]

Hi Rupert

The calculation does not seem right.

for period 1 : Result = 100

2: 100+200-0 =300

3: 300+40 -25 = 315

4: 315+40 -25 = 330

[Roop]

The results are the same now except that I have made Exp2 in period 1 set to zero as it does not figure in the calculation.

[#4]

Hi Rupert

I have checked the attached qv it showing the same result.

It is showing:

It must show

Please assist!!

[Roop]

apologies - I did not include the correct application .....

[#6]

Hi Rupert

Appreciate your effort.

I can see the Exp1 and Exp2 is not providing the origianl values but the cumulative values.

I would like to see the below:

Please advise if it is possible.

[Roop]

Sorted ....

I was showing the YTD values for Exp1 and Exp2. I have left them in the chart as commented out so you can revert to using them if you wish later on.

[#8]

Hi Rupert

Thanks for your reply!

Exactly the same I was getting.

But the result is not right. Please check the highlighted numbers.

It must show :

If we performing the cumulative calculation on same row then it is not giving correct result.

Please help.

[Roop · Accepted solution]

[#10]

Thanks a Million Rupert.

Much appreciated!