Hello everyone and thanks in advance, I can not create a slicer that filters not only by the main table, too by a secondary table that should be linked with the firts table with field key that is the reference.
In other words, the main table is the one of students 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.
I cant attach example sheet to te post
In other words, the main table is the one of students 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.
I cant attach example sheet to te post