如何在透视表中添加列

方法 1

方法 1 的 2:将字段更改为列

WH.shared.addScrollLoadItem(‘1a42a14e4541be56ee39dfe210aebc92’)

WH.performance.clearMarks(‘image1_rendered’); WH.performance.mark(‘image1_rendered’);{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a0/Add-a-Column-in-a-Pivot-Table-Step-1-Version-4.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-1-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a0/Add-a-Column-in-a-Pivot-Table-Step-1-Version-4.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-1-Version-4.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
1
打开要编辑的透视表文件。在电脑上找到该文件并双击打开。
如果你还没做透视表,那就打开新的Excel文件并创建一个透视表。WH.performance.mark(‘step1_rendered’);

WH.shared.addScrollLoadItem(‘02266fcb0863e8b6aa829f5ea58b9b7a’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/ce/Add-a-Column-in-a-Pivot-Table-Step-2-Version-5.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-2-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/ce/Add-a-Column-in-a-Pivot-Table-Step-2-Version-5.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-2-Version-5.jpg”,”smallWidth”:460,”smallHeight”:346,”bigWidth”:728,”bigHeight”:547,”licensing”:”

“}
2
单击透视表的任意位置。这样就能选中该表,而顶部工具栏会出现透视表分析和设计选项卡。

WH.shared.addScrollLoadItem(‘8373a28d2b27b8343d3b45e92a4c9cd4’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/c/cf/Add-a-Column-in-a-Pivot-Table-Step-3-Version-5.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-3-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/c/cf/Add-a-Column-in-a-Pivot-Table-Step-3-Version-5.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-3-Version-5.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
3
点击顶部的透视表分析。该选项卡位于页面顶部的公式、插入和视图等选项卡旁边,可在工具栏中显示透视表工具。
在某些版本中,该选项卡被命名为分析,而在其他版本中,则位于”透视表工具”下的选项中。

WH.shared.addScrollLoadItem(‘156e6d329987f985d96be7e0c4bd400e’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/7/7f/Add-a-Column-in-a-Pivot-Table-Step-4-Version-5.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-4-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/7/7f/Add-a-Column-in-a-Pivot-Table-Step-4-Version-5.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-4-Version-5.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:545,”licensing”:”

“}
4
点击工具栏的字段列表。该按钮位于透视表分析选项卡的右边,可用于打开所选表格中所有字段、行、列和值的列表。

WH.shared.addScrollLoadItem(‘1b5cdff61d9f87316c2e955f6f19bd4c’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/a/a9/Add-a-Column-in-a-Pivot-Table-Step-5-Version-5.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-5-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/a/a9/Add-a-Column-in-a-Pivot-Table-Step-5-Version-5.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-5-Version-5.jpg”,”smallWidth”:460,”smallHeight”:344,”bigWidth”:728,”bigHeight”:544,”licensing”:”

“}
5
选中字段名称列表中任意一条旁边的复选框。这样能计算出所选范围内原始数据的摘要,并作为新列加入透视表中。
非数值字段通常增加为行,而数值字段则默认增加为列。
你可以随时取消复选框来移除列。

WH.shared.addScrollLoadItem(’68de798d831f00e24a92b8b7bfaa2b30′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/82/Add-a-Column-in-a-Pivot-Table-Step-6-Version-4.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-6-Version-4.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/82/Add-a-Column-in-a-Pivot-Table-Step-6-Version-4.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-6-Version-4.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:550,”licensing”:”

“}
6
将任意字段、行或值拖放至”列”的位置。这样能自动将所选内容移动到“列”列表中,并根据新增的列重新设计透视表。

WH.ads.addBodyAd(‘method_ad_1’)

广告

WH.ads.addBodyAd(‘mobilemethod_ad_1’)

方法 2

方法 2 的 2:添加计算字段

WH.shared.addScrollLoadItem(‘595ea7a7c0b8ad12f1c6fbc2854d6ed2’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/9/9e/Add-a-Column-in-a-Pivot-Table-Step-7-Version-5.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-7-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/9/9e/Add-a-Column-in-a-Pivot-Table-Step-7-Version-5.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-7-Version-5.jpg”,”smallWidth”:460,”smallHeight”:345,”bigWidth”:728,”bigHeight”:546,”licensing”:”

“}
1
打开要编辑的Excel文档。双击包含透视表的Excel文档。
如果你还没做透视表,那就打开新的Excel文件并创建一个透视表。

WH.shared.addScrollLoadItem(‘0f51b0e05e7b0e627d49485e7792f1c4’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/b/b3/Add-a-Column-in-a-Pivot-Table-Step-8-Version-5.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-8-Version-5.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/b/b3/Add-a-Column-in-a-Pivot-Table-Step-8-Version-5.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-8-Version-5.jpg”,”smallWidth”:460,”smallHeight”:348,”bigWidth”:728,”bigHeight”:551,”licensing”:”

“}
2
选中要编辑的透视表。单击工作表上的透视表进行编辑。

WH.shared.addScrollLoadItem(‘7f8c0536888f067f98130e027999622c’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/dc/Add-a-Column-in-a-Pivot-Table-Step-9-Version-3.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-9-Version-3.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/dc/Add-a-Column-in-a-Pivot-Table-Step-9-Version-3.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-9-Version-3.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
3
单击透视表分析选项卡。该选项卡位于页面顶部工具栏的中间,可打开工具栏中的透视表工具。
在不同版本中,该选项卡可能会叫做分析,或在”透视表工具”下的选项中。

WH.shared.addScrollLoadItem(‘cde9653863c0be4ffff5800eefed15c3’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/5/55/Add-a-Column-in-a-Pivot-Table-Step-10.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-10.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/5/55/Add-a-Column-in-a-Pivot-Table-Step-10.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-10.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
4
单击工具栏中的字段、项目和集合选项。该按钮位于工具栏右下角,图标上有”fx”标志,可打开一个下拉菜单。

WH.shared.addScrollLoadItem(’48efd3c7312c8baa50610e19fa92c297′)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/6/6c/Add-a-Column-in-a-Pivot-Table-Step-11.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-11.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/6/6c/Add-a-Column-in-a-Pivot-Table-Step-11.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-11.jpg”,”smallWidth”:460,”smallHeight”:347,”bigWidth”:728,”bigHeight”:549,”licensing”:”

“}
5
单击下拉菜单中的计算字段。这样将打开一个新窗口,可以在透视表中增加新的自定义列。

WH.shared.addScrollLoadItem(‘9e388fee072662026f5280051a5e3f9c’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/d/d4/Add-a-Column-in-a-Pivot-Table-Step-12.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-12.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/d/d4/Add-a-Column-in-a-Pivot-Table-Step-12.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-12.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
6
在”名称”字段中输入列的名称。单击名称字段,输入新列的名称,该名称会出现在列的顶端。

WH.shared.addScrollLoadItem(‘4193f37238d8b612f56690b89ce3585c’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/4/4b/Add-a-Column-in-a-Pivot-Table-Step-13.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-13.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/4/4b/Add-a-Column-in-a-Pivot-Table-Step-13.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-13.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
7
在”公式”字段中为新列输入公式。点击名称下面的公式字段,输入用于计算新列数值的公式。
公式要在”=”的右边。
也可以选择将现有的列作为值添加至公式中。选中要添加的字段,单击插入字段将其添加至公式中。

WH.shared.addScrollLoadItem(‘c92adca85e5a13a9a647c8eea23c8818’)

{“smallUrl”:”https://www.wikihow.com/images_en/thumb/8/8e/Add-a-Column-in-a-Pivot-Table-Step-14.jpg/v4-460px-Add-a-Column-in-a-Pivot-Table-Step-14.jpg”,”bigUrl”:”https://www.wikihow.com/images/thumb/8/8e/Add-a-Column-in-a-Pivot-Table-Step-14.jpg/v4-728px-Add-a-Column-in-a-Pivot-Table-Step-14.jpg”,”smallWidth”:460,”smallHeight”:343,”bigWidth”:728,”bigHeight”:543,”licensing”:”

“}
8
单击确定。这样就将列添加至透视表的右边了。

广告

WH.ads.addBodyAd(‘mobilemethod_ad_2’)

发表评论

您的电子邮箱地址不会被公开。 必填项已用*标注