| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pivot tables for likert-scale type survey items | Excel Worksheet Functions | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
| Pivot Table for survey results with set of possible answers in PT's Rows Field? | Excel Discussion (Misc queries) | |||
Threaded Mode
