Summary of multiple tables

It sounds like what you’re describing is a requirement to union two or more tables. There’s a nice example of how to combine data from multiple tables here: Data Hierarchy and Aggregration