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
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_level allocation_level_title_c sport Tennis location University of Southern California sport Tennis location University of Southern California sport Tennis location Northwestern University sport Tennis location UNLV sport Tennis location Indiana University sport Tennis location University of South Florida sport Tennis location University of Central Florida sport Tennis location Middle Tennessee State University sport Tennis location Long Island University - Post sport Tennis location TCU
And this is what i want to make Plz help me out!
Sport Location 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