Pivottable Calc. Avg. field based upon monthly data

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top