Mar 28 2019 01:09 AM
I need to cumulate incrementing values down.
Please see the attached file for better explanation.
Thank you in advance!
Mar 28 2019 01:19 AM
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?
Mar 28 2019 01:23 AM
Mar 28 2019 01:26 AM
please see the picture in attachment. I want to perform that incrementing cummulative action in pivot in the red marked area.
Thanks in advance
Mar 28 2019 01:30 AM
Mar 28 2019 02:15 AM
@Ubaid ur Rahman , so, like in your Excel file example but within PivotTable, correct?
Mar 28 2019 02:18 AM
@Sergei Baklan yes! as shown in the picture that how to simply apply that above formula to that column.
Mar 28 2019 02:31 AM
@Ubaid ur Rahman and how do you pivot first column, what gives 2.27 in Grand total?
Mar 28 2019 02:41 AM
@Sergei Baklan I don't need grand total. It comes up auto. So if possible without Grand total.
Mar 28 2019 03:32 AM
Solution@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.
Mar 28 2019 03:32 AM
Solution@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.