3 Replies Latest reply: Nov 19, 2017 3:32 PM by Neil Gabin RSS

    Count the number of students each teacher has in a table

    Neil Gabin

      Hi Data


      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?