Pivot 365 Row Name issue with Y/N Columns

[Morgaine659]

Hi All, I just moved over to Excel 365 and am having issues with Pivot Tables and Row Names for Y/N columns. Below is an example of my data. The output I need is what the total costs for Need and Required are. What I received is either 1) Row for Y and Row for (blank) [does not include actual column name], or 2) if I filter to Y only, it creates 2 columns (instead of Rows) with no $$ in Sum. I've tried to change the blank cells to N, but it just adds N to the options/row names.

Thank you!

[TABLE="width: 359"]
<colgroup><col><col><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD="align: left"]Want (Y/N)[/TD]
[TD="align: left"]Need (Y/N)[/TD]
[TD="align: left"]Require (Y/N)[/TD]
[TD="align: left"] USD $ [/TD]
[/TR]
[TR]
[TD="align: left"]Team 1[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD="align: left"] $ 100[/TD]
[/TR]
[TR]
[TD="align: left"]Team 2[/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[TD="align: left"] $ 1,000[/TD]
[/TR]
[TR]
[TD="align: left"]Team 3[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"] $ 200[/TD]
[/TR]
[TR]
[TD="align: left"]Team 4[/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[TD="align: left"] $ 350[/TD]
[/TR]
[TR]
[TD="align: left"]Team 5[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD="align: left"] $ 700[/TD]
[/TR]
[TR]
[TD="align: left"]Team 6[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD="align: left"] $ 550[/TD]
[/TR]
[TR]
[TD="align: left"]Team 7[/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[TD="align: left"] $ 620[/TD]
[/TR]
[TR]
[TD="align: left"]Team 8[/TD]
[TD][/TD]
[TD]Y[/TD]
[TD][/TD]
[TD="align: left"] $ 715[/TD]
[/TR]
[TR]
[TD="align: left"]Team 9[/TD]
[TD]Y[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: left"] $ 1,100[/TD]
[/TR]
[TR]
[TD="align: left"]Team 10[/TD]
[TD][/TD]
[TD][/TD]
[TD]Y[/TD]
[TD="align: left"] $ 250[/TD]
[/TR]
</tbody>[/TABLE]