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