Pivot Table No Formula Results on Total

B

Bozidar Bozic

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula within Pivot Table Calculated Field - Days in time period 0
Formula re value in column C or D, calculations made on either in column E? 8
Pivot table-show Q3 and Q4 with non filtered Total 0
Pivot table -Show Q3 and Q4 with non-filtered Total 0
Pivot Table calculated field error 2
pivot table 1
Unwanted Total in Pivot Table row field 3
Summarsing Variable Pivot Table Data 1

Top