How to aggregate loop and merge data into one visualization?

Hello -

I created a survey which includes loop and merge to enable up to 10 sets of survey responses. This is part of a site-level assessment that includes teacher feedback and up to 10 teachers can provide feedback on one site-level assessment. The loop and merge function was used to enable the data enterer to enter all of their data for one site into one survey response.

However, I am now building out a template report and finding it difficult to aggregate the loop and merge data into one visualization. Each template report is filtered to include just one site's worth of information, but as I said, up to 10 sets of survey responses. I have 5 questions in each set. I want to be able display a visualization that aggregates all 10 of the responses for question 1, all 10 of the responses for question 2, etc.

I am not able to determine a way to do this and Qualtrics customer support is no help. The only way I can imagine doing this is to create a new variable in which I sum all 10 responses for each of those 5 questions. I am just hoping that there is a more efficient way to do this.

Any suggestions or guidance would be appreciated!

Thanks!