bmurch71
Board Regular
- Joined
- Oct 15, 2004
- Messages
- 68
Hi,
I have a sales by department history table with date, dept number and sales total. I'm trying to create a report that will calculate a running average of sales by department and day of week for the last four weeks. In other words, I want a report that will show the average of the last 4 Mondays of sales in the grocery department - and so on for the other days of the week and other departments. Anyone have any clever solutions to this?
Thanks,
Brian
I have a sales by department history table with date, dept number and sales total. I'm trying to create a report that will calculate a running average of sales by department and day of week for the last four weeks. In other words, I want a report that will show the average of the last 4 Mondays of sales in the grocery department - and so on for the other days of the week and other departments. Anyone have any clever solutions to this?
Thanks,
Brian