Pivot Table

Hi,

I am doing a research project requiring me to find a correlation between answers to an assessment and the respondent's demographic information (example data attached). Is there a way to ask excel to do the pivot table only including records where in the last collum the answer is "Y." I tried filtering it and it still includes all 10 records.

Thanks!

Look at the attached. I filtered the Y/N column for only Y's. Seems to work ok for me.