pivot table

[Tiffany]

hi

I am using window vista and office 2007. I would like to create a formula
field in my pivot table using existing field. E.g. i would like to use the
sales field divided by the quantity field to derive the average price. How to
create the average price field? kindly help.

Thanks!

 

[Daniel.C]

Hi.
Clik on "pivot table tools", "Options" tab and "formulas". Choose
"calculated field". Enter a name, click on the "Sales" field and click
on "Insert field", enter a "/", click on the "Quantity field" and click
on "Insert field". Click "OK" and use the new field in the pivot table.
HTH
Daniel