You can aggregate across multiple rows if you use a separate table to aggregate related records. I've done this for a small nonprofit to aggregate event registr

You can aggregate across multiple rows if you use a separate table to aggregate related records. I've done this for a small nonprofit to aggregate event registration data by year by linking the registration records to a new year table. Sounds kludgy, but it works.