cgal slicer_使用Excel Slicer筛选器进行细化

cgal slicer

With Slicers in Excel 2010, you can easily filter several pivot tables with a single click. In the screen shot below, the Slicers are filtering the Severity and Priority fields in the pivot table. However, there is a problem with Drill to Detail with Excel Slicer Filters, in some version.

使用Excel 2010中的“切片器” ，只需单击一下即可轻松过滤多个数据透视表。 在下面的屏幕截图中，切片器正在过滤数据透视表中的“严重性”和“优先级”字段。 但是，在某些版本中，“使用Excel Slicer筛选器进行详细钻取”存在问题。

细化到意想不到的结果 (Unexpected Results With Drill to Detail)

Thanks to a tip from AlexJ, I learned that Slicers, combined with a pivot table's Drill to Detail feature, can produce unexpected results.

多亏了AlexJ的提示，我了解到Slicers与数据透视表的“钻取至细节”功能结合使用可以产生意想不到的结果。

Double-click on a pivot table's data cell, and a new sheet is inserted in the workbook, with a list of the records that are included in the cell that you double-clicked. For example, in the screen shot above, there are 2 records in the detail sheet, if you double-click on cell G6.

双击数据透视表的数据单元格，然后在工作簿中插入一个新工作表，其中包含双击的单元格中包含的记录列表。 例如，在上面的屏幕快照中，如果双击单元格G6，则明细表中有2条记录。

But what happens if you remove the Priority Report Filter from the pivot table, and filter with the Priority Slicer? The quantity in cell G6 is still 2.

但是，如果您从数据透视表中删除“优先级报告过滤器”，并使用“优先级切片器”进行过滤，会发生什么情况？ G6单元格中的数量仍为2。

But, when you double-click on cell G6 now, with the Priority field removed from the layout, the detail sheet looks different. There are 8 records, instead of 2 – all of the Priority values are included, not just the "20" priorities.

但是，当您现在双击单元格G6时，从布局中删除了“优先级”字段时，详细信息表看起来就不同了。 有8个记录，而不是2个–包括所有优先级值，而不仅仅是“ 20”个优先级。

怪癖还是功能？ (Quirk or Feature?)

Is this a quirk or a feature? I'm voting that it's a quirk. When I double-click, only the records behind the visible number should be displayed in the detail list.

这是怪癖还是功能？ 我投票这很奇怪。 双击时，明细列表中仅应显示可见数字后面的记录。

Keep this quirk in mind, if you're using Excel Slicers to filter the data, and then you use the Drill to Details (Show Details) feature. Only the fields that are in the pivot table layout will be filtered in the detail results sheet.

如果您使用的是Excel Slicers来过滤数据，然后使用“钻取至详细信息(显示详细信息)”功能，请记住这一点。 详细数据表中只会过滤数据透视表布局中的字段。

If you're using a macro to automate the drill to details feature, you might not notice that the results include non-filtered items. To prevent errors, you could add all the slicer fields to the pivot table layout, and that will ensure that the details list includes only the expected records.

如果您使用宏来自动执行“钻取至细节”功能，则可能不会注意到结果中包含未过滤的项目。 为了防止错误，您可以将所有切片器字段添加到数据透视表布局中，这将确保详细信息列表仅包含预期的记录。

下载样本文件 (Download the Sample File)

To test the effect of Slicer filters on the pivot table drill to detail feature, you can download Alex's sample file, PT0026 – Pivot Table Slicer Detail, from the Contextures website.

要测试“切片器”过滤器对“透视表钻取细节”功能的效果，可以从Contextures网站下载Alex的样本文件PT0026 –“透视表切片器详图” 。

NOTE: Slicers are only available in Excel 2010, so you won't see them in earlier versions.

注意 ：切片器仅在Excel 2010中可用，因此在早期版本中将看不到它们。

观看详细钻探视频 (Watch the Drill to Detail Video)

To see the steps for connecting multiple pivot tables to a slicer, then drilling to the details, please watch the short tutorial video below.

要查看将多个数据透视表连接到切片器，然后钻取细节的步骤，请观看下面的简短教程视频。

演示地址

翻译自: https://contexturesblog.com/archives/2012/03/22/drill-to-detail-with-excel-slicer-filters/

cgal slicer