4 Replies Latest reply on Sep 4, 2018 11:24 AM by Noha Abdou

    Group by aggregate question

    Noha Abdou

      Hello, I am new to this forum.  How can I achieve the following in Tableau?  I have ID's in Dimensions and Enrolled Units in Measures.

       

      Here is what my dataset looks like:

       

      Student IDEnrolled UnitsCourse
      13Englsh 101
      13Math 101
      13Psych 101
      22English 201
      22Sociology 101
      22Math 201
      33Englsh 101
      33Math 101
      33Psych 101
      42English 201
      41Sociology 101
      41Math 201
      52Englsh 101
      52Math 101
      52Psych 101

       

      I would like to group by aggregated Enrolled Unit Counts:

       

      Total UnitsTotal Students
      92
      62
      41

       

      Thanks!