How to create Last three months rolling average

[#1]

I have one requirement, How to calculate the last three months rolling average. How to calculate it.

I have one Year field and one month field and calculate the every last three months rolling avg. We need to create rolling average is the one more field. How can i do that.

[nilesh_gangurde]

if possible please attach the sample qvw file.

-Nilesh

[MK_QSL]

Calculating rolling n-period totals, averages or other aggregations

[#4]

I need to create the last three months rolling avg field.

[#5]

Anybody give me the suggestion.

[#6]

Any body can help me how to create last three months rolling average.

[#7]

You should be able to use something like this in a set to calculate this:

rangeavg(above(sum([Market Share Units - MKT UOM]),0,3))

Best,

Matt

[#8]

Thanks Matt, But I need back-end formula. i want to create the another list box for Rolling Average. Above is not working in the back-end.