SUM(列)/COUNT(列)在Excel PivotTable中不起作用 [英] SUM(column) / COUNT(column) not working in Excel PivotTable

问题描述

我在Excel中有一个数据透视表，并且我试图添加具有自定义计算的自定义字段，但是它似乎不起作用.截至目前，数据透视表如下所示……

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

myCustomField的公式如下:

The formula for myCustomField looks like this:

= SUM(Ordered) / COUNT(Ordered)

myCustomField的值应为875，但不是.我在做什么错或对此不了解?此外，即使可以将自定义计算添加到数据透视表之外的列中并可以工作，我还是需要表的一部分，这就是为什么要通过自定义字段添加它的原因.谢谢.

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.

推荐答案

不要使用像这样的计算字段，而是将另一个Value放入数据透视表中，并使其成为有序平均值".

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

这篇关于SUM(列)/COUNT(列)在Excel PivotTable中不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！