Hello everybody;

I am having difficulties to set up a pivot table that could help me
analyzing responses received from a questionnaire. I have fields "Districts"
and "Subdistricts" (both coded with numbers) and all the questions code with
"Q1", Q2a", etc... as column headers.
All the responses have been coded with numbers from 1 "very satisfied" to 12.
What I am trying to achieve is to be able to count how many 1, 2, 3, ... for
each question. Once I have this, I would aslo like to have an idea of the
values in percentage (% compared to the total amount of questionnaires).

Could somebody give me a hand. I hope the question is clear enough.

Many thanks