+ Reply to Thread
Results 1 to 2 of 2

Survey reporting with pivot tables

  1. #1
    Registered User
    Join Date
    12-05-2012
    Location
    California
    MS-Off Ver
    Excel 2007/2010
    Posts
    2

    Survey reporting with pivot tables

    I'm trying to use pivot tables to summarize data from a survey. Unfortunately the survey produces raw data that appears to be extremely unfriendly for use with pivot tables. I've attached a spreadsheet with a few questions, with the raw data in one tab and the tables in a second tab.

    Q1 is easy to report with a pivot table, however, Q2 is a multiple choice question with nonexclusive options, so each option is considered a sub-question with a yes/no answer to indicate whether it was selected. You can see I created the format of the table I'm looking for with just manual copy/paste and some formulas, however I'd like to be able to create this with a pivot table instead. Does anyone know if this is possible?

    Any help or nudges in the right direction would be greatly appreciated. I haven't had any success searching for the answer, but I might just not know the right terminology to search with.

    Here is the spreadsheet:
    jl_survey_data_12-05.xls

    Thanks!
    -Jeff

  2. #2
    Registered User
    Join Date
    12-05-2012
    Location
    California
    MS-Off Ver
    Excel 2007/2010
    Posts
    2

    Re: Survey reporting with pivot tables

    Figured it out, the answer was to convert Yes/No answers to 1/0 and use the sum function instead of count

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1