Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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)
Hi @vinieme12 ,
Aggr by month was excluded as everything appears as - when I added it in, not sure what I'm doing wrong here.
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)
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?
post a sample
Please post a sample