Forum Discussion
Solved
Excel Cumulative Sum
I need to cumulate incrementing values down. Please see the attached file for better explanation. Thank you in advance! SergeiBaklan
Ubaid ur Rahman , I tried to do that on your data model, but didn't catch what do you calculate in it. Thus emulate on the table
It is named as Range in data model, the measure will be
CumulativeCountDifd:=CALCULATE ( SUM ( [Actual value] )/COUNTROWS(Range), FILTER ( ALLEXCEPT ( Range, Range[Year] ), Range[Month] <= MAX ( Range[Month] ) ) )You may it in Power Pivot and result is in second sheet.
Hi Ubaid ur Rahman ,
If to repeat your formula to make it more universal when
=SUM(B$4:$B4)/COUNT(B$4:$B4)
Or you mean something else?
Hi Baklan,
thanks for your quick reply. I got this but what the real problem is how to perfrom this action in Pivot table. I have a month coulumn form 1 to 12. Then in second column I have an average of some numbers repeating monthly. in the third I want to perform the above action.
thanks for your quick reply. I got this but what the real problem is how to perfrom this action in Pivot table. I have a month coulumn form 1 to 12. Then in second column I have an average of some numbers repeating monthly. in the third I want to perform the above action.