Hopefully I can explain what I'm trying to do clearly.
The table I'm working with has records for each student. There is a portal in this layout that lists what number the student ranked each studio. It will always be ranked 1-9. So the portal just contains the field Rank and Studio.
What I need to do is summarize a count of how many people ranked each studio 1,2,3,4,5,6,7,8, or 9.
The other problem is that I want this at the end of a layout. The report above it is a listing of each student and their respective studio rankings.
I attached a picture of how it looks now which is how I want it to look. But I had to create 162 fields just for the totals to work. And I have to change them every year when the studio names change. I figured there's a better way.
Thanks for you help. I've been trying to figure this out for a couple months and haven't gotten anything that wasn't really messy.