Town ExtrYear (C4) ExtrWeek (C2) NumSales I NumMtgs I
Avon 2002 02 10 4
Boston 2002 02 300 100
etc.
User selects a week range (could be 4,5,12 weeks, whatever) and wants to see data in this way:Town Frequency Recorded Week 1 Week 2 Week3 ... Avon 4 2 S:10 M:4 S:4 M:2 Boston 4 3 S:300 M:100where frequency is taken from another table (predefined for each town) and Recorded is calculated (count for !empty(Num) in week, e.g. if we have Sales in Week1 and Week3 it would be 2)