I was hoping that someone could provide me some assitance in calculating a running average in a pivot table or straight table when using a date as a dimension. I am assuming that I have to use set analysis but I am having some dificulty with finding the correct expression.
Rangeavg(above(Count(count),0,12)) This expression will give a rolling 12 month average including the current row, and going back 11 rows. If you want everything before each row averaged then Rangeavg(above(Count(count),0,noofrows())) should work
Rangeavg(above(Count(count),0,12)) This expression will give a rolling 12 month average including the current row, and going back 11 rows. If you want everything before each row averaged then Rangeavg(above(Count(count),0,noofrows())) should work
