Excel中的链接表和切片器 [英] Linked tables and Slicer in excel

问题描述

我无法在excel中创建切片器，该切片器不仅通过主表进行筛选，还通过次要表进行筛选，该次要表应使用作为引用的字段键与第一个表链接.

I can not create a slicer in excel that filters not only by the main table, too by a secondary table that should be linked with the first table with a field key that is the reference.

换句话说，主表是具有唯一ID作为参考的学生表.辅助表格是每个学生参加的课程.

In other words, the main table is the students table with a unique ID that is reference. The secondary table are the classes that each student attends.

我希望切片器进行过滤，每个学生都参加哪个班级并向我显示学生表，并且仅显示与辅助表中的切片器选择相匹配的学生.这可能吗?

I want the Slicer to filter, to which classes each student attends and shows me the student table, only with the students that match the slicer selection of the secondary table. Is this possible?

基本上，这就像在Access中进行选择.

Basically it would be like doing a select in Access.

抱歉，我无法在此帖子中添加示例文件，而是添加了

Sorry I can't add an example file to this post and I add a link to dropbox

推荐答案

如果您具有Excel 2013或更高版本，则可以导入两个表并将它们添加到数据模型.那么您可以使用字段键将数据模型中的这两个表链接起来.之后，您可以在查找表上使用切片器来过滤两个表.

If you have Excel 2013 or above, you can import both tables and add them to data model. then you can link those two tables in data model with a field key. After that you can use slicer on lookup table to filter both tables.

这篇关于Excel中的链接表和切片器的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！