Cumulative Sum of an Average

[John]

Hi!

is anyone know how to do cumulative sum of an average? or any alternative solution below?

for above data, I want to have a cumulative average of a column so i can have the the total hours on the last step. Thanks!

 

[Vincent Thuilot]

Hi John,

Yes there are a few options:

The main one would be like this:
Avg([Sales]) THEN SUM([Value]) OVER (AllPrevious([Axis.Rows])) 

it calculates the cumulative sum of the avg, here the results:


when doing this you could also be interested in calculating the avg of all avg up to a certain row, and that would give this (Option 2):

Avg([Sales]) THEN Avg([Value]) OVER (AllPrevious([Axis.Rows])) 

 

You can generate these fast by using the Cumulative SUM out-of-the-box option and tweak the code to replace the first SUM by AVG.

 

Hope it helps!

Edited June 4 by Vincent Thuilot

[Gaia Paolini]

Are you looking at adding the averages, or calculating the global average? 

[John]

Hi Gaia,

I'm looking for adding the average. Thanks!