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