数据表字段命名规则_重命名数据透视表值字段

数据表字段命名规则

重命名数据透视表值字段 (Renaming a Pivot Table Value Field)

When you add a field to the pivot table Values area, it's automatically given a custom name, such as Sum of Units.

当您将字段添加到数据透视表的“值”区域时，系统会自动为其指定一个自定义名称，例如“单位总数”。

You might want to change the custom name to Units, so it's easier to read and makes the column narrower.

您可能需要将自定义名称更改为“单位”，因此更易于阅读并使列更窄。

However, if you select the cell and type Units, you'll get an error message: "PivotTable field name already exists."

但是，如果选择单元格并键入“单位”，则会收到错误消息：“数据透视表字段名称已存在”。

使用略有不同的名称 (Use a Slightly Different Name)

If you try to create a custom name that's the same as a field name in the source data, you'll see the error message. In this example, because one of the fields in the source data is named Units, you can't use Units as a custom name in the pivot table.

如果您尝试创建一个与源数据中的字段名称相同的自定义名称，则会看到错误消息。 在此示例中，由于源数据中的一个字段名为“单位”，因此您不能在数据透视表中将“单位”用作自定义名称。

However, you can avoid this problem, by adding a space character to the end of the custom name, and it will be accepted.

但是，您可以通过在自定义名称的末尾添加一个空格字符来避免此问题，并且该名称将被接受。

Or, if you have multiple value fields in the pivot table, select all the captions, and use the Replace All command to fix all the captions at once.

或者，如果数据透视表中有多个值字段，请选择所有标题，然后使用“全部替换”命令立即修复所有标题。

1. In the Find What box, type "Sum of"
   在“查找内容”框中，键入“总和”
2. Leave the Replace With box empty
   将替换为框留空
3. Click Replace All.
   单击全部替换。

This will leave a space at the start of the caption, so it's different than the original field name, and will be accepted.

这将在标题的开头保留一个空格，因此它与原始字段名称不同，将被接受。

翻译自: https://contexturesblog.com/archives/2009/05/04/renaming-a-pivot-table-value-field/

数据表字段命名规则