Hello,

I'm trying to calculate the average price per metric tonne, using formula
calculated field, in Excel 2003 pivot table. But when I expand at the country
detail to supplier level it doesn't give me the average price at the total
row.

A particular supplier we will only use until the end of June. This seems to
cause no average price calculation for Q3 and Q4 periods.

Any suggestions to overcome this problem?

Much appreaciated
--
Bozidar Bozic