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!

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

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!