Pivot table Yes and No data

[lobo19]

Hi,

I need to put yes and no data into one pivot table. I've tried to do this when I put the data into a pivot table in the values group I get the same no and yes count as the category I have selected for Rows, which is wrong. Any advice on troubleshooting this issue?

 

[Eric W]

Welcome to the forum.

What does your data look like, and what results do you want? For example, with this table:

	A	B	C
1	Name	Value	Filter
2	a	yes	1
3	b	yes	1
4	c	no	1
5	d	yes	1
6	e	yes	1
7	f	no	2
8	g	no	2
9	h	no	2
10	i	no	2
11	j	yes	2
12	k	no	2

<tbody>
</tbody>

Sheet1​

I generated this Pivot table:

	A	B	C
1	Filter	2
2
3	Row Labels	Count of Name
4	no	5
5	yes	1
6	Grand Total	6
7
8

<tbody>
</tbody>

Sheet3​

by dragging Filter to the Filters box, Value to the Rows box, and Name to the Values box (somewhat counterintuitive).