3 Replies Latest reply on Jul 20, 2016 7:26 AM by Tom W

    Understand # of respondents who indicated 1, 2, 3, or 4 levels of interest

    Alissa Swartz

      I'm working on analyzing some survey data. I'm trying to understand the number of respondents who indicated that they were only interested in 1 level of interest, and those who indicated 2, 3, or 4 levels of interest (levels of interest = on the rows). So basically, out of the total people who were interested in AD (row 1) - 1395 - how many ONLY said AD interest, and how many said that they were also interested in EL, OL, and/or PL. I'd also want to see the subtotals.

       

      How would I create this table? Here is the straight cut:

       

       

      And here is what happens when I add the question text to the columns also (note I grouped "am interested" and "could be interested" and filtered only to 2016 for ease of viewing):