Linked tables and Slicer in excel -


i can not create slicer in excel filters not main table, secondary table should linked first table field key reference.

in other words, main table students table unique id reference. secondary table classes each student attends.

i want slicer filter, classes each student attends , shows me student table, students match slicer selection of secondary table. possible?

basically doing select in access.

sorry can't add example file post , add link dropbox

if have excel 2013 or above, can import both tables , add them data model. can link 2 tables in data model field key. after can use slicer on lookup table filter both tables.


Comments

Popular posts from this blog

php - Embed BBCode within itself not working -

three.js - how to load gltf in three JS -

sql server - T-SQL: Access DB objects in same schema without qualifying? -