I'm hoping someone can help... it seems like there should be an easy way to do this, but I'm stumped. I've searched for help on the topic, but can't find exactly what I'm looking for.
I have a query that pulls in data from 2 different tables. I need to come up with a way to show a total for EACH project, and then add a total for each group of projects (subcouncil). It basically needs to look like this: