Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Pivot Table Filter For Multiple Survey Responses
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Pivot Table Filter For Multiple Survey Responses

    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/1gRY...ew?usp=sharing

    Thank you!

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,022
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

    file is NOT shared
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  3. #3
    New Member
    Join Date
    Nov 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

    Sorry! Permissions have been updated.

  4. #4
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,022
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Pivot Table Filter For Multiple Survey Responses

    something like this?

    Teacher (All)
    Sum of Value Grade
    Attribute
    1
    K Grand 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
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  5. #5
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,022
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Cool Re: Pivot Table Filter For Multiple Survey Responses

    or this

    Teacher (All)
    Count of Value Grade Value
    1
    1 Total K K Total Grand 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
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  6. #6
    New Member
    Join Date
    Nov 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

    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?

  7. #7
    New Member
    Join Date
    Nov 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

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

  8. #8
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,022
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

    like this one?

    Teacher (All)
    Attribute Q1
    Count of Value Grade
    Value
    1
    K Grand 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
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  9. #9
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    3,022
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

    so choose the post you want
    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    I don't use vba in any form!

  10. #10
    New Member
    Join Date
    Nov 2014
    Posts
    16
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Pivot Table Filter For Multiple Survey Responses

    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

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •