J
James Yeang
Hi, calling out anyone who can help with pivot tables
Here's my scenario:
3 people are asked a few questions, where their responses can be
grouped as "Yes" or "No".
I need to be able to count the number of Yes and No responses to Q1,
Q2, Q3 in a pivot table and then be able to Zoom in by user...
eg. This is the sample data collected
Q1 Q2 Q3
Jimmy Yes No Yes
Jack No Yes Yes
Jill Yes No Yes
and this is how I want to pivot table to look like....
Page: Username (eg. All users)
Q1 Q2 Q3
Yes 2 1 3
No 1 2 0
Try as I may, I cannot get it to appear that way. Can anyone please
help me with the layout, or tell me what I need to be selecting?
Here's my scenario:
3 people are asked a few questions, where their responses can be
grouped as "Yes" or "No".
I need to be able to count the number of Yes and No responses to Q1,
Q2, Q3 in a pivot table and then be able to Zoom in by user...
eg. This is the sample data collected
Q1 Q2 Q3
Jimmy Yes No Yes
Jack No Yes Yes
Jill Yes No Yes
and this is how I want to pivot table to look like....
Page: Username (eg. All users)
Q1 Q2 Q3
Yes 2 1 3
No 1 2 0
Try as I may, I cannot get it to appear that way. Can anyone please
help me with the layout, or tell me what I need to be selecting?