CODEWITHSUNDEEP
excelpivot-table
Waxi
Waxi

Reputation: 1651

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

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.

Upvotes: 0

Views: 1863

Answers (1)

Joel Spolsky
Joel Spolsky

Reputation: 33637

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

Upvotes: 3

Related Questions