I have two tables with the same structure, but different data sets. Eg: Client #1, and Client #2.

I want to generate a summary chart that will total by month.

I would like to get the total number of 'bookings' by month, but I want to total the number out of multiple data tables that exist in the same workspace. ideally, it would be good if I could point to different workspaces, but I have duplicated the data into a new 'Summar' Workspace to have a one-stop dashboard to provide an overview.

Any clues from anyone how I can make this happen please?

Thanks

Steve