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.