software

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 quot;Yesquot; or quot;Noquot;.

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?I don't think I'd use a pivottable.

I'd just use a few formula:

Q1 Q2
Yes =countif(sheet1!b:b,a2) =countif(sheet1!c:c,a2) ....
No =countif(sheet1!b:b,a3) =countif(sheet1!c:c,a3) ....

Change the sheet name and column addresses accordingly.

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

--

Dave Peterson

Dave:
Is a Pivot Table even possible?
I made a couple attempts at creating, but all failed..
Tks,
Jim Mayquot;Dave Petersonquot; wrote:

gt; I don't think I'd use a pivottable.
gt;
gt; I'd just use a few formula:
gt;
gt; Q1 Q2
gt; Yes =countif(sheet1!b:b,a2) =countif(sheet1!c:c,a2) ....
gt; No =countif(sheet1!b:b,a3) =countif(sheet1!c:c,a3) ....
gt;
gt; Change the sheet name and column addresses accordingly.
gt;
gt; James Yeang wrote:
gt; gt;
gt; gt; Hi, calling out anyone who can help with pivot tables
gt; gt;
gt; gt; Here's my scenario:
gt; gt; 3 people are asked a few questions, where their responses can be
gt; gt; grouped as quot;Yesquot; or quot;Noquot;.
gt; gt;
gt; gt; I need to be able to count the number of Yes and No responses to Q1,
gt; gt; Q2, Q3 in a pivot table and then be able to Zoom in by user...
gt; gt;
gt; gt; eg. This is the sample data collected
gt; gt;
gt; gt; Q1 Q2 Q3
gt; gt; Jimmy Yes No Yes
gt; gt; Jack No Yes Yes
gt; gt; Jill Yes No Yes
gt; gt;
gt; gt; and this is how I want to pivot table to look like....
gt; gt;
gt; gt; Page: Username (eg. All users)
gt; gt;
gt; gt; Q1 Q2 Q3
gt; gt; Yes 2 1 3
gt; gt; No 1 2 0
gt; gt;
gt; gt; Try as I may, I cannot get it to appear that way. Can anyone please
gt; gt; help me with the layout, or tell me what I need to be selecting?
gt;
gt; --
gt;
gt; Dave Peterson
gt;

I think you'd have to change your data (maybe use 1 for yes and 0 for know).
Then you could count/sum what you want.

But I don't think you'll get what you want.

It would be a lot easier if the data were laid out like:

Name Question Resp
Jimmy Q1 Yes (or 1)
Jimmy Q2 No (or 0)
.....Jim May wrote:
gt;
gt; Dave:
gt; Is a Pivot Table even possible?
gt; I made a couple attempts at creating, but all failed..
gt; Tks,
gt; Jim May
gt;
gt; quot;Dave Petersonquot; wrote:
gt;
gt; gt; I don't think I'd use a pivottable.
gt; gt;
gt; gt; I'd just use a few formula:
gt; gt;
gt; gt; Q1 Q2
gt; gt; Yes =countif(sheet1!b:b,a2) =countif(sheet1!c:c,a2) ....
gt; gt; No =countif(sheet1!b:b,a3) =countif(sheet1!c:c,a3) ....
gt; gt;
gt; gt; Change the sheet name and column addresses accordingly.
gt; gt;
gt; gt; James Yeang wrote:
gt; gt; gt;
gt; gt; gt; Hi, calling out anyone who can help with pivot tables
gt; gt; gt;
gt; gt; gt; Here's my scenario:
gt; gt; gt; 3 people are asked a few questions, where their responses can be
gt; gt; gt; grouped as quot;Yesquot; or quot;Noquot;.
gt; gt; gt;
gt; gt; gt; I need to be able to count the number of Yes and No responses to Q1,
gt; gt; gt; Q2, Q3 in a pivot table and then be able to Zoom in by user...
gt; gt; gt;
gt; gt; gt; eg. This is the sample data collected
gt; gt; gt;
gt; gt; gt; Q1 Q2 Q3
gt; gt; gt; Jimmy Yes No Yes
gt; gt; gt; Jack No Yes Yes
gt; gt; gt; Jill Yes No Yes
gt; gt; gt;
gt; gt; gt; and this is how I want to pivot table to look like....
gt; gt; gt;
gt; gt; gt; Page: Username (eg. All users)
gt; gt; gt;
gt; gt; gt; Q1 Q2 Q3
gt; gt; gt; Yes 2 1 3
gt; gt; gt; No 1 2 0
gt; gt; gt;
gt; gt; gt; Try as I may, I cannot get it to appear that way. Can anyone please
gt; gt; gt; help me with the layout, or tell me what I need to be selecting?
gt; gt;
gt; gt; --
gt; gt;
gt; gt; Dave Peterson
gt; gt;

--

Dave Peterson

Thanks for the additional input;
Jim

quot;Dave Petersonquot; wrote:

gt; I think you'd have to change your data (maybe use 1 for yes and 0 for know).
gt; Then you could count/sum what you want.
gt;
gt; But I don't think you'll get what you want.
gt;
gt; It would be a lot easier if the data were laid out like:
gt;
gt; Name Question Resp
gt; Jimmy Q1 Yes (or 1)
gt; Jimmy Q2 No (or 0)
gt; .....
gt;
gt;
gt; Jim May wrote:
gt; gt;
gt; gt; Dave:
gt; gt; Is a Pivot Table even possible?
gt; gt; I made a couple attempts at creating, but all failed..
gt; gt; Tks,
gt; gt; Jim May
gt; gt;
gt; gt; quot;Dave Petersonquot; wrote:
gt; gt;
gt; gt; gt; I don't think I'd use a pivottable.
gt; gt; gt;
gt; gt; gt; I'd just use a few formula:
gt; gt; gt;
gt; gt; gt; Q1 Q2
gt; gt; gt; Yes =countif(sheet1!b:b,a2) =countif(sheet1!c:c,a2) ....
gt; gt; gt; No =countif(sheet1!b:b,a3) =countif(sheet1!c:c,a3) ....
gt; gt; gt;
gt; gt; gt; Change the sheet name and column addresses accordingly.
gt; gt; gt;
gt; gt; gt; James Yeang wrote:
gt; gt; gt; gt;
gt; gt; gt; gt; Hi, calling out anyone who can help with pivot tables
gt; gt; gt; gt;
gt; gt; gt; gt; Here's my scenario:
gt; gt; gt; gt; 3 people are asked a few questions, where their responses can be
gt; gt; gt; gt; grouped as quot;Yesquot; or quot;Noquot;.
gt; gt; gt; gt;
gt; gt; gt; gt; I need to be able to count the number of Yes and No responses to Q1,
gt; gt; gt; gt; Q2, Q3 in a pivot table and then be able to Zoom in by user...
gt; gt; gt; gt;
gt; gt; gt; gt; eg. This is the sample data collected
gt; gt; gt; gt;
gt; gt; gt; gt; Q1 Q2 Q3
gt; gt; gt; gt; Jimmy Yes No Yes
gt; gt; gt; gt; Jack No Yes Yes
gt; gt; gt; gt; Jill Yes No Yes
gt; gt; gt; gt;
gt; gt; gt; gt; and this is how I want to pivot table to look like....
gt; gt; gt; gt;
gt; gt; gt; gt; Page: Username (eg. All users)
gt; gt; gt; gt;
gt; gt; gt; gt; Q1 Q2 Q3
gt; gt; gt; gt; Yes 2 1 3
gt; gt; gt; gt; No 1 2 0
gt; gt; gt; gt;
gt; gt; gt; gt; Try as I may, I cannot get it to appear that way. Can anyone please
gt; gt; gt; gt; help me with the layout, or tell me what I need to be selecting?
gt; gt; gt;
gt; gt; gt; --
gt; gt; gt;
gt; gt; gt; Dave Peterson
gt; gt; gt;
gt;
gt; --
gt;
gt; Dave Peterson
gt;

Thanks guys...