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.
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?
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