Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table for survey results with set of possible answers in PT's Rows Field?
Hi, I'm trying to use a Pivot Table to present some survey results, and could use a point in the right direction. Details: - The first question is "what department do you work for?" - The rest of the questions all have the same options as answers (agree, strongly, disagree, strongly disagree). - The questions are the column headings in the source data set. I'm looking to: - have the columns be the four options, and the rows be the individual questions. - be able to split out and/or compare the answers by department. Is this possible using Pivot Tables? I tried having the Department be the "Page Field" and various combinations of placing the other fields in the Row Fields, Column Fields & Data Fields, but to no avail. Could anyone give me a pointer or two in the right direction? Thanks in advance for any help, :)Ben Ben Nardone Business Systems Analyst Pathfinder International, www.pathfind.org 617-924-7200 x605 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - divide two results | Excel Worksheet Functions | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) | |||
pivot table results - with value in every row and column | Excel Discussion (Misc queries) | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) |