last date only moving averaged display

[Anonymous]

I am looking for a 3 days moving average - I can calculate it,  using

rangeavg(above(sum(Score),0,3))

but I want to display only the result for the highest date.

so instead of

I would like to see only the yellow highlighted one, when I try to filter my calculation changed since it is ignoring the non filtered. .

I tried to apply so set analysis to it but did not help.

Any idea?

[sunny_talwar · Accepted solution]

Enabled the other two expressions also

[Anonymous]

no maybe because I am using Q11 and you are Q12 , I see:

[Anonymous]

Sorry all, I see it now, not sure why I open another file first.

[sunny_talwar]

Q11 or Q12 should not make any difference... are you still not seeing what I posted?