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 possible answers
(agree, strongly, disagree, strongly disagree).

- The questions are the column headings in the source data set.

In the Pivot Table, I'm looking to:
-----------------------------------
- have the rows be the individual questions (col headings from data set)
- have the columns be the four possible answer (col data from data set)
- have the data be the occurence of the possible answers for each of the
columns
- 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 PT's "Page Field" and various
combinations of placing the other fields in the Row Fields, Column
Fields & Data Fields, but to no avail.

It doesn't seem to want to let me have mulitple rows of questions; instead
it seems to want to make me have separate Pivot Table's for each question.

Could anyone give me a pointer or two in the right direction?

Thanks in advance for any help,

:)Ben