Pivot Table Filter For Multiple Survey Responses

Sheepeys

New Member
Hi!
I have a spreadsheet with data from a survey: 9 questions, each with an answer between 1 and 5. I have a pivot table that shows me a breakdown of how many of each answer (1 through 5) there is for a single question. Is there a way that I can include all of my data and filter by question, so I don't need to create 9 different pivot tables, but I can still see the information for a single question?

I'm unsure how to attach a file, but here is a link to my spreadsheet on Google Drive ("Sheet 1" is my current attempt at a pivot table):
https://drive.google.com/file/d/1gRYVuhFjkMkqFJvUmMp7ol0psoHI3WBn/view?usp=sharing

Thank you!
 

sandy666

Well-known Member
something like this?

Teacher(All)
Sum of ValueGrade
Attribute
1
KGrand Total
Q1
100​
92​
192​
Q2
121​
76​
197​
Q3
117​
66​
183​
Q4
120​
120​
Q5
129​
67​
196​
Q6
124​
80​
204​
Q7
129​
74​
203​
Q8
136​
136​
Q9
106​
61​
167​
Grand Total
1082
516
1598
 

sandy666

Well-known Member
or this

Teacher(All)
Count of ValueGradeValue
1
1 TotalKK TotalGrand Total
Attribute
1
2
3
4
5
1
2
3
4
5
Q1
36​
9​
8​
3​
2​
58​
10​
4​
4​
8​
6​
32​
90​
Q2
26​
14​
13​
2​
4​
59​
8​
11​
7​
5​
1​
32​
91​
Q3
25​
17​
13​
1​
3​
59​
13​
10​
5​
2​
2​
32​
91​
Q4
26​
9​
13​
8​
1​
57​
57​
Q5
22​
8​
11​
7​
6​
54​
16​
6​
3​
5​
2​
32​
86​
Q6
25​
4​
11​
12​
2​
54​
11​
8​
5​
2​
6​
32​
86​
Q7
16​
18​
12​
4​
5​
55​
14​
6​
5​
2​
5​
32​
87​
Q8
29​
4​
11​
4​
10​
58​
58​
Q9
35​
3​
10​
5​
3​
56​
19​
7​
2​
4​
32​
88​
Grand Total
240
86
102
46
36
510
91
52
29
26
26
224
734
 

Sheepeys

New Member
I'm actually looking for something like the pivot table I already have, showing the results for one question, but with the ability to easily switch between questions, through maybe another drop-down filter?
 

Sheepeys

New Member
Sorry, I just saw your second response. That's very much what I'm looking for! I can build graphs from that. Perfect!
 

sandy666

Well-known Member
like this one?

Teacher(All)
AttributeQ1
Count of ValueGrade
Value
1
KGrand Total
1​
36​
10​
46​
2​
9​
4​
13​
3​
8​
4​
12​
4​
3​
8​
11​
5​
2​
6​
8​
Grand Total
58
32
90
 

Sheepeys

New Member
I like the second to last one (with all the questions in rows and the choices in columns). How do I recreate it?

Thank you!
 

Some videos you may like

This Week's Hot Topics

Top