I am new to Tableau and i am trying to create a set based on two fields of a survey response. As shown below, i have responses to different questions of a survey over two years 2000 and 2001. I want to create a set containing all the individuals that responded 'Y' to Q1 AND 'Y' to Q2.
I tried to create two seperate sets by creating one for Q1 'Y' and another for Q2 'Y' and then creating a combined set with both but the combined set has no data.
Attached is my workbook with the sample data. Please advise how to go about doing this.
Thank you for your help and time.