This content has been marked as final. Show 3 replies
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):