I am trying to prepare a report that tells me how many students have done course ABC and course XYZ.
Our data output contains one record per student per course. So if a student has done more than 1 course, they will appear in the data for how many courses they have done.
The ideal outcome is to get a matrix styled report that looks like below:
Course Names Course A Course B Course C Course D
Course A - 5 0 20
Course B 5 - 6 7
Course C 0 6 - 1
Course D 20 7 1 -
Can anyone suggest a solution to achieve this?
Aucun commentaire:
Enregistrer un commentaire