2 Replies Latest reply on May 19, 2017 2:52 PM by Jeep Hauser

    Merging or blending or combining columns? Not sure which applies here!

    Jeep Hauser

      Hi folks,

       

      I'm working with data about students (using Tableau 10.1.8), and the relevant part on students with multiple majors looks like this:

       

      Student IDSchoolSchool 2School 3
      213Business
      123BusinessEngineering
      532BusinessCommunication
      689Engineering

       

      I want to get a count of how many students from each school responded (there isn't one school that can be identified as a 'primary' school). For the above example, it would look like this:

       

      SchoolStudents
      Business3
      Communication1
      Engineering2
      TOTAL4

       

      Is it possible to get this without doing ETL on the source data? My calculation skills are very new.

       

      Thanks,

      Jeep