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