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

Pivottable Calc. Avg. field based upon monthly data
 

Sorry Jan. should of course show: 25,00 and Feb. should show. 58,33
--
preben


"prebang" skrev:

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