I have a basic survey form where a user selects a company name and then answers 10 questions with a 1 to 5 rating scale for the answer to each question.
I am trying to create a report that will list the provider on a page and then below it, going down on the left side is each question and then out to the right side of the question are fields for how many responses answered 1, how many chose 2, how many chose 3, and so forth. I cant seem to figure this out. Thus it may look something like this (i hope it formats properly for this forum)
Scale rating 1 2 3 4 5
------------------------------------------------------
PROVIDER1 3 2 5 7 8
PROVIDER2 1 1 3 4 4