I have the following example tables:
Table1- Course information
Table2- Users in courses
Table3 - User information
Table1 is linked to Table2 on CourseID to show the users in the course, then Table2 is linked to Table3 on UserID to show further information about the users.
I want to show under-represented majors, so in this case, I want Major3 and Major4 to display in say, a multi-row card as it is not present in any courses.
How can I show the values NOT present in the filter? "Show items with no data" does not seem to work.