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:
- 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).
- 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.