I'd neet to get weekly averages in a Pivot Table. The source data may contain
several lines for one week. How can I get AVG weekly volume/customer/quarter
from this kind of data?

Any advice is greatly appreciated!

Customer Volume Origin Year Q Month Week
XXX 3000 A 2007 1 1 1
YYY 1000 A 2007 1 1 1
ZZZ 150 A 2007 1 1 1
XXX 350 A 2007 1 1 2
XXX 4000 L 2007 1 1 2
YYY 100 A 2007 1 1 2
YYY 800 L 2007 1 1 2
ZZZ 100 A 2007 1 1 2
ZZZ 150 L 2007 1 1 2
XXX 1000 A 2007 1 1 3
XXX 3000 L 2007 1 1 3
XXX 150 T 2007 1 1 3
YYY 500 A 2007 1 1 3
YYY 400 L 2007 1 1 3
ZZZ 200 L 2007 1 1 3
XXX 3500 A 2007 1 1 4
XXX 700 L 2007 1 1 4
YYY 1000 A 2007 1 1 4
YYY 500 L 2007 1 1 4
ZZZ 200 A 2007 1 1 4
XXX 3500 A 2007 1 2 5
XXX 300 L 2007 1 2 5
YYY 300 A 2007 1 2 5
YYY 1800 L 2007 1 2 5
ZZZ 50 A 2007 1 1 5
ZZZ 150 L 2007 1 1 5