| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivottable Calc. Avg. field based upon monthly data
Hi to every one. Can any one tell me if following example-case is possible,
please: row Numbers unit price tot price Avg. pr month Running Avg Jan 100 pcs 25,00 2500,00 25,00 25,00 Feb 200 pcs 75,00 15000,00 75,00 58,33 Mar 250 pcs 100,00 25000,00 100,00 77,27 I can create a calculated Average colum . pr. month with no problem. I just can`t figure out how to get shown - in the pivottable - a colum as shown in above example, giving me a running actual average pr. month. I have spent days to try and figure this out and therefore your respons will be highly apreciated. -- preben |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable - summing more than one data field | Excel Discussion (Misc queries) | |||
| function to reference all of pivottable data field array | Excel Worksheet Functions | |||
| How do I count unique items in a pivottable data field. | Excel Discussion (Misc queries) | |||
| Pivottable data field | Excel Discussion (Misc queries) | |||
| IRR calc Monthly vs Annual | Excel Worksheet Functions | |||
Threaded Mode
