6 Replies Latest reply on Nov 20, 2018 8:35 AM by Deepak Rai

    How to count a distinct number of occurrences using two columns

    brendan parla

      How to do I count a distinct number of occurrences using two columns?  Example of data below.

       

      I want to count the distinct number of students in the resource category column.  Essentially count the distinct number or resources who fall under the resource category of teacher.

       

      Resource       Resource Category

      Mike               Teacher

      John               Student

      Jill                  Student

      Chris              Student

      Steve            Teacher

      Joe                Principal

      Bob               Student

      Ally               Nurse