SUM(column) / COUNT(column) not working in Excel P

Question

I have a PivotTable in Excel, and I'm trying to add a custom field with a custom calcuation, but it doesn't seem to work. As of right now, the PivotTable looks like this...

Part        Count of Ordered        Sum of Ordered        myCustomField

ABC         4                       3500                  3500

The formula for myCustomField looks like this:

= SUM(Ordered) / COUNT(Ordered)

The value for myCustomField should read 875, but it's not. What am I doing wrong or not understanding about this? Also, even though this custom calculation could be added in a column outside of the PivotTable and work, I need it part of the table which is why I'm adding it through a custom field. Thank you.

Answer 1

Instead of using a calculated field like this, put another Value in your pivot table and make it the Average of Ordered.