Forum Discussion

Ubaid ur Rahman

Brass Contributor

Mar 28, 2019

Solved

Excel Cumulative Sum

I need to cumulate incrementing values down. Please see the attached file for better explanation. Thank you in advance! SergeiBaklan

Cummulation.xlsx2.1 MB

SergeiBaklan
Mar 28, 2019
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.
Cummulation.xlsx2.1 MB

Diamond Contributor

Mar 28, 2019

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?

Cummulation.xlsx2.1 MB

Ubaid ur Rahman

Brass Contributor

Mar 28, 2019

please see the picture in attachment. I want to perform that incrementing cummulative action in pivot in the red marked area.

Thanks in advance

SergeiBaklan
Diamond Contributor
Mar 28, 2019
Ubaid ur Rahman , so, like in your Excel file example but within PivotTable, correct?
- Ubaid ur Rahman
  Brass Contributor
  Mar 28, 2019
  SergeiBaklan yes! as shown in the picture that how to simply apply that above formula to that column.
  - SergeiBaklan
    Diamond Contributor
    Mar 28, 2019
    Ubaid ur Rahman and how do you pivot first column, what gives 2.27 in Grand total?

Resources