Hopefully you're looking for something like the below and attached?
I joined the two worksheets in the Tableau Workbook. From Column I used 'Division' to INNER join on First Preference I used Division Name (which I renamed from F1 which is how it was originally named). Then it was simply a matter of placing the pills as shown. Also, you'd have to go to Analysis in the menu and uncheck Aggregate Measures. Then created a parameter based on Question Option. Then a calculated T|F (boolean) calculation to filter the data based on Question Option. Lastly, I created a dynamic Title which updates when user selects the parameter choice.
If this answers your question please mark it as correct so that others may find it in their search for a solution in the future. Best, Don How to Mark an answer as Correct
We would love to hear your feedback on your Tableau Community Forums experience.
Please take this 5 minute survey.
Book3.twbx 2.1 MB
Thanks Don, brilliant!
I need to get my head around data prep and joining.
That T/F is nice and easy.