I must have missed the boat about calculated fields in Pivot tables.
A simple exercise to calculate an extended price, being the product of Quantity and Unit Price
incorporated into a pivot table seems to yield the product of the sums, not the sum of the products.
Is this so or have I missed something?
If the response is to calc all Extended Price in the source data then what is the hoopla about pivot tables and the ability to create derived data etc (from Office 2000 on)
If the problem here is between the keyboard and the back of the chair then I will appreciate some one extending my education.
Otherwise it is a case of being aware of the limitations I guess.