数据透视表切片器显示空白_使用切片器显示数据透视表值

数据透视表切片器显示空白

Instead of adding and removing pivot table values one at a time, click a Slicer, to quickly add and remove them, in groups. Most pivot tables won't need this, but for source data with lots of numeric fields, this slicer technique can make things easier.

单击“切片器”以成组快速添加和删除它们，而不是一次添加和删除数据透视表值。 大多数数据透视表都不需要这样做，但是对于具有大量数字字段的源数据，这种切片器技术可以使事情变得更容易。

切片器演示 (Slicer Demo)

In this example, there’s a table with work order data, and a pivot table based on that data. There are two Slicers above the pivot table:

在此示例中，有一个包含工单数据的表，以及一个基于该数据的数据透视表。 数据透视表上方有两个切片器：

• Click the Group Slicer, to quickly show values from the selected category.
  单击“组切片器”，以快速显示所选类别中的值。
• Click the Function slicer to set the function and heading for each value
  单击功能切片器以设置功能和每个值的标题

源数据编号字段 (Source Data Number Fields)

This pivot table is based on a table with work order records, and about half of the