I have a table of student enrollments for the Fall 2014 semester (Student ID + Course + a lot of other info). I have another table of info regarding which students have declared minors in our department (Student ID + minor + other info).
I would like to link these tables in PowerPivot so that I can see, for instance, what courses our Film Production minors are taking.
One student can take multiple classes (thus the student enrollments table has duplicates of student IDs) and one student can declare multiple minors (thus the minors table also has duplicate student IDs). I made a third table with just Student IDs, with duplicates removed, and made a relationship from that table to the Student ID field in each of the other tables. This however isn't providing me with the data I need in my PivotTable (Value field: Count StudentIDs from enrollment table, Row Fields: Minors from minors table and Course Title from enrollment table).
Any help would be appreciated!
Bookmarks