Finding a percentage from survey data


Not sure what formulas/table configuration I should be using here. I have a table of responses to pre and post-program surveys and want to be able to compare the responses to the pre to those of the post (See image below).

For each question in the survey, I would like to know the following:

  1. how many people responded with each answer for each survey (ie: 8 people said they weren’t at all excited in the pre-survey but only two said they weren’t at all excited in the post-survey).
  2. The percent of people who responded with each answer only out of those who answered that particular question.

I know this will most likely involve linking records and rollup fields in a separate table but I have been trying to figure this out and nothing has been working. Any and all suggestions would be so helpful.

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.