Data Model Relationship Troubles

I am struggling (again!) in trying to understand creating Relationships with a DataModel

I've made a basic sample that has 3 tables. The goal/exercise is to be able to pick a a 'SiteGroup' and then get the Revenue and Expense for those locations.

So I have a 'CompanyList' table that list 50 locations.
And then a 'SiteGroup' Table that puts these locations into different groups.
And a data table listing locations and some revenue/expense numbers.

And then have a relationship (1 to many) between the CompanyList and SiteGroup and another relationship (1 to many) between CompanyList and Data.

From everything I understand, I think this should be working? Excel doesn't even want to detect and make the relationships automatically either, and I have to manually create them. Even though same column names and types.

Can anyone possibly point out where I'm going wrong?

Sample File attached.

Edit: Updated Sample attached as was not fully sanitized the data, but still not working as expected.

Thanks,
PT

SiteScreenShot.png

I would guess you need a table Sites that just has your 5 groups - then your current Sitegroups table would become a join table, I have not set up tables like a DB in excel before, but do you need ID's?

That is why I was thinking an additional table - however, good for the work around