Average of the past three years based on selection

[Anonymous]

What function/expression could I use to average the sum of something over the past three years (based on the user selecting a year)?

Thanks

Greg

[Anonymous]

My last expression is not a proportion.

Regards!

[sunny_talwar · Accepted solution]

I guess I understand your issue, you need to ignore selection in academic year field

Sum({<Year={">$(=max(Year)-3)<=$(=Max(Year))"}, source={'HESASTUD'},gender ={'Male'}, academic_year>} head) /

Sum({<Year={">$(=Max(Year)-3)<=$(=Max(Year))"}, source={'HESASTUD'}, academic_year>} head)

[Anonymous]

Thanks for all your help guys.