I've decided to make a second table called Demographics, which links to the primary table Schools.
For each school, I have the same dozen demographics, broken down by category and grouping. I've used the record template tool to generate a blank demographic set for a school.
This allows me to create charts on a school level and total aggregate in interfaces.