This content has been marked as final. Show 3 replies
My data set is made up of 6 Grades, 20 Teacher, 275 Student and not every teacher teaches every Grade
I need a table that has Teacher Name, No. of Grades, No. of Student but I end up getting 6 Grades and 275 students for every teacher.
My expression is... Aggr(Count(distinct [Grade]), [Teacher])
What am I doing wrong?