| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivottable calc. avg. field based upon monthly running price
PLEASE HELP ME ANY ONE WITH AN ANSWER ON MY QUESTION RAISED 16.09.07:
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 25,00 Feb 200 pcs 75,00 15000,00 75,00 58,33 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 -- preben |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivottable Calc. Avg. field based upon monthly data | Excel Discussion (Misc queries) | |||
| calculate/convert volume price to monthly average price | Excel Worksheet Functions | |||
| How do I calc. acrued intrest on a monthly investment over 35 yr | Excel Worksheet Functions | |||
| IRR calc Monthly vs Annual | Excel Worksheet Functions | |||
| Shadows of the Pivottable Field List while macro is running | Excel Worksheet Functions | |||
Linear Mode
