Dan,
Have a look at some of the thread links below first.
LINK1
LINK2
LINK3
LINK4
LINK 5
I think, however, you need to look at month last year, weight it against
up or down shift this year.
Trying to do it week against week / day against day is a hiding to nothing.
IE: Take the month from last year, the average daily distribution then
weight it for volume changes YTD against last year.
I take it you've just got the job :-)
Have fun
DaveA
 |