3 Replies Latest reply on Aug 16, 2018 10:56 AM by Naveen B

    Classification of data in the same column into main category and sub-category

    Raja Singh

      Want to make by putting four categories of sports in the first column, some value of the same column is to make it's sub-category? Please help to resolve?

       

      In below excel screen capture sport is one category and location is other one.

       

         

      sportTennis15
      locationUniversity of Southern California15

       

       

      And i want to make this like below -

       

       

       

      University of North Carolina - Charlotte
      Soccer
      University of North Florida
      University of South Carolina
      University of South Florida
      Volleyball
      University of Southern California
      UNLV

      Wichita State University

       

       

      Please help!

        • 1. Re: Classification of data in the same column into main category and sub-category
          Naveen B

          Hi Raja,

           

          Create a sets for both the conditions and drag it to view

           

          This will help you out.

           

          If it didn't helps kindly attach the workbook or sample data so that it will be easy to decipher

           

          BR,

          NB

          • 2. Re: Classification of data in the same column into main category and sub-category
            Raja Singh

            Thank you Naveen for your response!

             

            I am new on tableau so if you please explain through example it's very helpful.

             

            This is excel -

             

             

              

            allocation_levelallocation_level_title_c
            sportTennis
            locationUniversity of Southern California
            sportTennis
            locationUniversity of Southern California
            sportTennis
            locationNorthwestern University
            sportTennis
            locationUNLV
            sportTennis
            locationIndiana University
            sportTennis
            locationUniversity of South Florida
            sportTennis
            locationUniversity of Central Florida
            sportTennis
            locationMiddle Tennessee State University
            sportTennis
            locationLong Island University - Post
            sportTennis
            locationTCU

             

             

            And this is what i want to make Plz help me out!

             

             

             

            SportLocation
            Tennis
            Arizona State University
            Brown University
            Capital University
            Colorado College
            Dartmouth College
            East Tennessee State University
            Hobart College
            Indiana University
            Kenyon College
            Long Island - Manhasset
            Long Island University - Post
            Miami University
            Middle Tennessee State University
            NC State University
            Northwestern University
            TCU
            Texas Tech University
            The College of Wooster
            The Penn Tennis Camp
            The University of Iowa
            The University of Notre Dame
            The Wellington School
            University of Central Florida
            University of North Carolina - Charlotte
            Soccer
            University of North Florida
            University of South Carolina
            University of South Florida
            Volleyball
            University of Southern California
            UNLV
            • 3. Re: Classification of data in the same column into main category and sub-category
              Naveen B

              Hi Raja,

               

              Could you please attach sample excel

               

              Check the below link : How to attach

               

              Attaching a Packaged Workbook

               

              BR,

              NB