Y and N in Excel

[lorisbooks]

I have Y and N answers in a multiple category spreadsheet. I am trying to pull them into a Pivot Table but, cannot seem to get it filtered correctly. The counts and Y/N are not filtering correctly.[TABLE="width: 500"]
<tbody>[TR]
[TD]Filters
[/TD]
[TD]Columns
[/TD]
[/TR]
[TR]
[TD]NONE
[/TD]
[TD]VALUE
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Rows
[/TD]
[TD]Values
[/TD]
[/TR]
[TR]
[TD]CORRELATED DATA
[/TD]
[TD]ALL COLUMNS NEEDING CORRELATED(5)
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[pbornemeier]

More details required for any coherent answer, but guessing:
Y/N in the Values section won't work. Change Y to 1 and N to 2 on your source data then the counts/filter will work

 

[lorisbooks]

More details required for any coherent answer, but guessing:
Y/N in the Values section won't work. Change Y to 1 and N to 2 on your source data then the counts/filter will work

Thanks so much.