Hi:
I have a table that I need help to summarize the data. I need to be able to
create one row of data for custno + prodno + period + weekno combination
summarized by Invtot.
Any help will be greatly appreciated.
Best regards
I am attaching the relevant info below:
Sales Table
CustNo
ProdNo
Period
WeekNo
InvTot
InvDate
Data
---------
CustNo ProdNo Period WeekNo InvTot InvDate
0001 0500 2007-01 01 111.11 2007/01/01
0001 0500 2007-01 01 112.11 2007/01/01
0001 0500 2007-01 01 113.11 2007/01/02
0001 0500 2007-02 01 114.11 2007/02/02
0001 0500 2007-02 01 115.11 2007/02/02
0001 0500 2007-02 01 116.11 2007/02/02
0001 0500 2007-04 21 117.11 2007/04/08
0001 0500 2007-04 21 118.11 2007/04/08
0001 0500 2007-04 21 119.11 2007/04/08
0001 0501 2007-05 25 111.11 2007/05/01
0001 0501 2007-05 25 112.11 2007/05/01
0001 0501 2007-05 25 113.11 2007/05/02
0001 0501 2007-05 25 114.11 2007/05/02
0001 0501 2007-06 30 115.11 2007/06/02
0001 0505 2007-06 30 116.11 2007/06/02
0001 0505 2007-06 30 117.11 2007/06/08
0001 0506 2007-06 30 118.11 2007/06/08
0001 0507 2007-06 30 119.11 2007/06/08
