Parent row possibility?

I have an idea but I'm not sure it's possible, need some advice.
I have a form I've created with an option to add 5 submissions. I need to be able to total these submissions based on who filled out the form. Right now I have a helper column that adds the submissions up that are on the row, but I wondered if I couldn't set it up to where each new submission falls on it's own row but under the same submitter name? I will attach a photo of how it's set up now for reference. I also looked at a formula to total these amounts based on the submitter but I can't make that work either.
Any ideas?
Answers
-
If you're on a Business or Enterprise plan, you can use a Report to Group and then Summarize rows, meaning that you can Group by who filled out the form, then summarize (such as SUM) the content in another column (or COUNT if you're looking for how many rows have come in).
Here's a free webinar on these features: Redesigned Reports with Grouping and Summary Functions
Cheers,
Genevieve
Help Article Resources
Categories
Check out the Formula Handbook template!