当你添加字段到数据透视表的数值区域时,格式会自动完成。
As you add fields to the Values area of the PivotTable, the formatting is done automatically.
为了使这些变得更容易,汇总功能在数值区域中的单元格菜单里被显露出来。
To make this very easy, the aggregation functions are now exposed in the context menu of cells in the Values area.
当您在数值区域里放置第二个字段的时候字段标题才会显示出来。这是因为我们不希望在透视表里加数值标题,除非里面有多个项目。
We don't show this field until you add a second field to the Values area because we don't put captions in the PivotTable until there are multiple items in the Values area.
应用推荐