Hi Max

In the PT
Drag Customer to Row area
Drag Q to Row area
Drag Week to Row area
Double click on these fields and set Subtotal to None
Drag Volume to Data area
Double click on Volume and change Sum to Average

--
Regards

Roger Govier


"Max Stenbäck" wrote in message
...
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