数据透视表中计算字段的总数？

I don't have access to a version of Excel that features inserting calculated fields, but I can demonstrate what is happening in your case (which you correctly identified in the question). I had to create another column with the rounded values, and then include that column in the pivot table:

You can see that the pivot table correctly summarizes the data when you do it this way (which is the solution to getting the result you want). If you need a calculation applied to each raw value prior to aggregating, do it outside of the pivot table.

What is happening in your case is that Excel is aggregating the raw income values from your data table, then applying the rounding calculation to the aggregate. So despite the column header label, the pivot table isn't performing the calculation you expect. The column label in your pivot table would more accurately be "Rounded of Sum".

Pivot tables are a fantastic tool for simple aggregations, but you need to be careful about the sequence in which Excel applies calculations vs. aggregating, especially when you apply calculated fields or even use aggregation functions that involve more complex calculations than simple summing or counting. For pivot tables with any complexity, it's a good practice to double check the results to confirm that it's doing what you want.

To preserve some of the discussion in the comment thread:

There are limitations to what you can do in a pivot table. If what you require is the aggregation shown in your example (aggregate, then round), you can't use a pivot table to spit out a total based on calculating it a different way. You would need to do that externally. But that won't necessarily break everything every time the data changes (although you will need to trigger recalculation of the pivot table).

From the discussion, you have some complex requirements that benefit from the aggregation the pivot table offers, but don't lend themselves to doing it in a simple, straightforward way. The best way to accomplish what you need may be combining calculations internal and external to the pivot table.

像我一样，将Rounded计算添加为提供数据透视表的另一个数据列。添加或修改客户记录时，这很容易维护。在数据透视表中，保留计算得出的舍入字段，因为这会以所需的形式显示汇总。如我的示例所示，添加另一个字段，它是新的舍入数据列的总和。然后，数据透视表将包含双向计算的所有内容，因此您所需的一切都在那里。

然后，您可以处理外观。您可以更描述性地标记列，但如果您不希望新列可见，则将其隐藏。您可以将单元格引用粘贴到其在透视表的可见部分下的总计，甚至重新创建自己的“总计”行并隐藏由透视表生成的行。