Annualized Dates - Grouping Overlap

[KMKelly]

I am trying to take a list of data by month and create a second list of annualized values (12 mos) based on the first list.

Jan 25
Feb 15
Mar 10
Apr 20
May 22 18.4
June 30 19.4
Jul 28 22.0

This is an example where I use a 5 month interval for the calculation. Starting in May which is the first month with 5 months worth of data, I do a mean of the 5 months ending May, in June it is 5 months ending June, etc...

Ususally when I run this I cut and paste to Excel and do the report there - does anyone know any way to query this in a simple way or do I need to code it all for each row. I can't just group because the ranges of dates overlap. Feb would be included in the averages for May and June, for example.

Thanks.

Kris

 

[r937]

you will need to join the table to itself using date or at least yymm ranges for the join

it would help to see the columns and their datatypes

rudy