View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
eastlaketech eastlaketech is offline
external usenet poster
 
Posts: 1
Default Pivot Table of Survey Data

I conducted a survey with over 1500 participants whose answered the questions
with SA, A, D or BD. I would like SA, A, D, DB as headings for the rows,
Questions 17 & 18 as my column heading, and the count for each answer (SA, A,
D, DB) as my data.

If I have 17 & 18 as my column heading, I only receive a grand total count.
If I add Question 17 to my ROW, it will show the SA, A, D, BD, however, the
data for column 18 is not correct.

Can anyone help?