excel透视表无添加字段_为内部字段添加数据透视表小计

excel透视表无添加字段

How was your weekend weather? We had a mini-blizzard yesterday, that covered the backyard with snow. But it was a good day to stay indoors, and work on Excel pivot tables!

你周末的天气怎么样？ 昨天我们有一场小型暴风雪，雪覆盖着后院。 但这是呆在室内并使用Excel数据透视表的好日子！

演示地址

数据透视表小计 (Pivot Table Subtotals)

I think the weather was better last April, when I posted a video about adding multiple subtotals for a pivot table field, and you can see that video at the end of this blog post.

我认为去年4月的天气更好，当时我发布了一个有关为数据透视表字段添加多个小计的视频，您可以在此博客文章的末尾看到该视频。

This week, Bob emailed a question about creating subtotals for the innermost fields, and showing subtotals for calculated fields. By default, there are no subtotals for the inner field, but you can force them to appear, by following the same steps, shown below, that you use to create multiple subtotals.

本周，鲍勃通过电子邮件发送了一个有关为最里面的字段创建小计，并显示已计算的字段的小计的问题。 默认情况下，内部字段没有小计，但是您可以按照下面显示的相同步骤(用于创建多个小计)来强制它们出现。

为数据透视表字段添加自定义分类汇总 (Add Custom Subtotals for Pivot Fields)

To show custom subtotals for the inner or outer pivot fields, follow these steps:

要显示内部或外部枢轴字段的自定义小计，请按照下列步骤操作：

1. Right-click on an item in the pivot field that you want to change. For example, right click on a region name cell, in the Region field
   右键单击要更改的数据透视字段中的项目。 例如，右键单击“区域”字段中的区域名称单元格
2. In the popup menu, click Field Settings
   在弹出菜单中，单击“字段设置”
3. In the Field Settings dialog box, on the Subtotals & Filters tab, click Custom
   在“字段设置”对话框的“小计和过滤器”选项卡上，单击“自定义”
4. Click on one or more summary function in the list of functions, then click OK
   单击功能列表中的一个或多个摘要功能，然后单击“确定”。

外字段的自定义小计 (Custom Subtotals for Outer Fields)

When you add custom subtotals for the outer fields, they appear below the pivot field items, even if you have selected the option to "Display All Subtotals at Top of Group."

当您为外部字段添加自定义分类汇总时，即使您已选择“在组顶部显示所有分类汇总”选项，它们也会显示在枢轴字段项目下方。

You can't change the order of the custom subtotals – they'll appear in the same order as in the list of functions.

您无法更改自定义小计的顺序，它们的显示顺序与功能列表中的顺序相同。

内部字段的自定义小计 (Custom Subtotals for Inner Fields)

When you add custom subtotals for the inner fields, they appear below the last outer field, just above the grand total. So, depending on the length of your pivot table, those inner subtotals might be pretty far from the pivot items that they're summarizing!

当您为内部字段添加自定义分类汇总时，它们将显示在最后一个外部字段下方，正好在总计上方。 因此，根据数据透视表的长度，这些内部小计可能与它们要汇总的数据透视表项相差很远！

计算字段小计的问题 (Problem With Calculated Field Subtotals)

If you have calculated fields in your pivot table, they will not show any custom subtotals. In the screen shot below, the Tax column is a calculated field, and its subtotals are blank. Stick with automatic subtotals, if you need to see subtotals for your calculated fields.

如果您在数据透视表中已计算字段，则它们将不会显示任何自定义小计。 在下面的屏幕快照中，“税收”列是一个计算字段，其小计为空白。 如果需要查看计算字段的小计，请坚持使用自动分类汇总。

下载样本工作簿 (Download the Sample Workbook)

To experiment with the pivot table subtotals shown in this example, you can download the Pivot Table Custom Subtotals Sample workbook. The file is in Excel 2007 format, and is zipped. The file does not contain any macros.

要试验此示例中显示的数据透视表小计 ，您可以下载数据透视表自定义小计样本工作簿 。 该文件为Excel 2007格式，并且已压缩。 该文件不包含任何宏。

视频：内部字段的数据透视表小计 (Video: Pivot Table Subtotals for Inner Fields)

To see the steps for adding custom subtotals to inner fields in a pivot table, watch this Excel video.

要查看将自定义小计添加到数据透视表的内部字段中的步骤，请观看此Excel视频。

演示地址

视频：多个数据透视表小计 (Video: Multiple Pivot Table Subtotals)

To see the detailed steps for adding fields and creating custom subtotals, watch this Excel video.

要查看添加字段和创建自定义小计的详细步骤，请观看此Excel视频。

演示地址

翻译自: https://contexturesblog.com/archives/2011/04/18/add-pivot-table-subtotals-for-inner-fields/

excel透视表无添加字段