Rolling Average to Ignore Date Filters

[User12321]

Hi,

I have a pivot table with columns MonthYear, Average Price and Rolling Average.

When date filter is selected, the column for Rolling Average displays either - or a wrong value. 

Any advise on what is wrong?

Thank you.

[vinieme12]

Don't refer the column instead use the full expression and ignore Month selection in set analysis

For example; if your expression for average is = Avg(Values)

Then

Aggr(RangeAvg(Above(Avg({<Month=>}Values),1,3)),Month)

[User12321]

Hi @vinieme12 ,

Aggr by month was excluded as everything appears as - when I added it in, not sure what I'm doing wrong here.

[vinieme12]

You need to wrap the below expression in aggr and aggr based on the dimensions used in the chart.  

Aggr(RangeAvg(Above(Avg({<Month=>}Values),1,3)), dimensionname1, dimensionname2)

[User12321]

Hi @vinieme12 ,

After aggr, the rolling averages only appears if I expand to the sub dimension. How can I also make the rolling averages appear in the overall dimension? 

[vinieme12]

post a sample

[vinieme12]

Please post a sample