透视表过滤_隐藏数据透视表明细而不进行过滤

透视表过滤

To focus on specific data in a pivot table, you can use report filters or field filters. You can also hide Pivot Table detail without filtering.

要专注于数据透视表中的特定数据，可以使用报表过滤器或字段过滤器。 您还可以隐藏数据透视表详细信息而无需过滤。

数据透视表报表过滤器 (Pivot Table Report Filters)

This screen shot shows a pivot table with East selected in the Region report filter.

此屏幕快照显示了在“区域”报告过滤器中选择了“东部”的数据透视表。

However, using those filters affects the pivot table subtotals and grand totals. Only the amounts for the filtered data are included in the results.

但是，使用这些过滤器会影响数据透视表的小计和总计。 结果中仅包含过滤数据的数量。

折叠或展开字段 (Collapse or Expand the Fields)

Another option for hiding the pivot table details is to collapse one or more of the items, so only its subtotal is showing. In the screenshot below, I'm about to click on the Collapse button for the Bars category in the pivot table.

隐藏数据透视表详细信息的另一种方法是折叠一个或多个项目，因此仅显示其小计。 在下面的屏幕截图中，我将要点击数据透视表中“酒吧”类别的“折叠”按钮。

The Bars data is still in the pivot table, but only its subtotal is showing, not the City detail rows. The subtotals for East and Bars are not affected.

条形图数据仍在数据透视表中，但仅显示其小计，而不显示城市详细信息行。 East和Bars的小计不受影响。

再次显示详细信息 (Show the Details Again)

After you're finished focusing on the specific data, you can show all the detail rows again.

在完成对特定数据的关注之后，您可以再次显示所有明细行。

A quick way to show all the details for a field is to right-click on an item in the field, such as Bars.

显示字段的所有详细信息的快速方法是右键单击该字段中的项目，例如“条”。

Then, in the popup menu, click Expand/Collapse, and click Expand Entire Field.

然后，在弹出菜单中，单击“展开/折叠”，然后单击“展开整个字段”。

观看数据透视表视频 (Watch the Pivot Table Video)

To see the steps for hiding or showing the detail items in a pivot table, watch this short Excel video.

要查看在数据透视表中隐藏或显示详细信息项的步骤，请观看此简短的Excel视频。

演示地址

翻译自: https://contexturesblog.com/archives/2012/01/17/hide-pivot-table-detail-without-filtering/

透视表过滤