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?

       

      Neil