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!