12 Month Moving Average

[DaveyDSmith]

I am reporting Unit Sales by Item and they are grouped by Month. I am trying to develop a formula that gives me the moving average unit sales for the previous 12 months. There will be 24 months on the report & I am currently using a Cross-Tab format and a Line Chart. I wish to have the actual monthly units as well as the moving average on the chart.

I am using CR v2008

 

[DaveyDSmith]

I haven't heard from anyone on this formula for a 12 month moving average.

 

[lbass]

Probably because what you want to do is complex. Maybe thread767-1487073 will help.

-LB

 

[DaveyDSmith]

if it were not a complex issue, I probably wouldn't be asking for help. Thanks for the related thread.