I am creating two pivot tables on two worksheets, and one of the fields is Number of Projects.
我在两个工作表上创建了两个数据透视表,其中一个字段是项目数。
When I put this field into a pivot table it becomes "Sum of Number of Projects".
当我将此字段放入数据透视表时,它变为“项目数量总和”。
There are two stages to my projects ("start" and "end") and each are on a separate worksheet.
我的项目有两个阶段(“开始”和“结束”),每个阶段都在一个单独的工作表上。
I want to create a graph, one for each worksheet showing "NUmber of Projects" where the name on the Graph in both instances is "Number of Projects".
我想创建一个图表,每个工作表显示一个图表,显示“NUmber of Projects”,其中两个实例中图表上的名称是“项目数”。
How can I achieve this and avoid the "Field name already exists error"?
如何实现这一点并避免“字段名称已存在错误”?
It appears to me as though the field name alias I give it in the Custom Name box in "Field Settings" can't be the same as the column heading in the worksheet (which you used to create the pivot table in the first place.
在我看来,好像我在“字段设置”的“自定义名称”框中给出的字段名称别名不能与工作表中的列标题相同(您首先用它来创建数据透视表)。
Is there any way of getting around this?
有没有办法解决这个问题?
One option is to add a space to the front or end of the pivot table field name but there has to be a better way.
一种选择是在数据透视表字段名称的前端或末尾添加一个空格,但必须有更好的方法。
为枢轴字段添加空间
1 个解决方案
#1
2
Adding a space at the end is conventional and the most practical workaround.
最后添加空间是传统的,也是最实用的解决方法。
#1
2
Adding a space at the end is conventional and the most practical workaround.
最后添加空间是传统的,也是最实用的解决方法。