Morgaine659
New Member
- Joined
- Feb 27, 2018
- Messages
- 1
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!
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Thank you!
| Want (Y/N) | Need (Y/N) | Require (Y/N) | USD $ | |
| Team 1 | Y | $ 100 | ||
| Team 2 | Y | $ 1,000 | ||
| Team 3 | Y | $ 200 | ||
| Team 4 | Y | $ 350 | ||
| Team 5 | Y | $ 700 | ||
| Team 6 | Y | $ 550 | ||
| Team 7 | Y | $ 620 | ||
| Team 8 | Y | $ 715 | ||
| Team 9 | Y | $ 1,100 | ||
| Team 10 | Y | $ 250 |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
