Average (measure) of last 7 days for a date range.

[JO]

Hi,

I have a requirement to find the average (measure) of last 7 days for a date range. User will enter the start and enddate , based on the date range i have to find the last 7 days average for each of the date and display it in cross tab. for ex:

start date : Aug-10-2008
End date: Aug -1-2008

Date                       Metric            Avg Metric
Aug-10-2008                X                  X
.
.
.
Aug-1-2008                X                  X

Can anyone help me on this?

Thanks
Jo