this questions has probably been asked many times before, but no matter how long I search for an answer, I cannot find anything useful.
I have two Tables (from different sources):
Table 1: Sales
Customer
Employee
Sales
A
1
100
A
2
150
A
3
80
B
1
70
B
4
90
Table 2: Work hours
Customer
Employee
Work Hours
A
1
1.5
A
2
3
A
3
2
A
4
1
B
1
1
B
4
3
In my data model, these tables are linked by "Customer".
Now, if in my analysis I create a table with the dimension "Customer" and the columns sum(WorkHours) and sum(Sales), I get the expected result., i.e. the sales and work hours per customer.
However, if I create an additional table with the dimension "Table1.Employee" (or "Table2.Employee") and the columns sum(WorkHours) and (Sales), I get wrong/unexpected results, not the sales and work hours per employee.
If I change my data model and link the tabels by "Employee" instead of "Customer", the second analysis works, but not the first.
