Hello, I have come across a similar situation where the business wants the users to see their data only but also see high level numbers of the overall business to compare themselves against. Reading about your solution of creating a separate fact table, i wanted to check how did that go or did you come up with another approach in this time ??
Regards
Grace