Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Weekly average in pivot
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
with weekly score sheet how do I column a weekly progressive aver. | Excel Worksheet Functions | |||
How to calculate the cumulative weekly average over several wksht | Excel Discussion (Misc queries) | |||
How to Get Sum of the Average in Pivot Table? | Excel Discussion (Misc queries) |