Groupby values from 2 non related tables

[kasun909]

Is there a way to SUMMARIZE 2 fact tables (Fact_Revenue and Fact_Expenses etc.) using one field on one of the fact table (For Example I have the client name in the Fact_Revenue table but I do not have it in any dimension or in the other Fact_Expenses table) But I want to summarize Expenses and Revenue by Client names. There is no relationship between these 2 fact tables as well. Please help.

[Anonymous]

If you do not have anything that references or relates to the client in the expense table, then how do you tell which expense belongs to which client?