Hi. I try to get the right sum when aggregating the department name from table A with sales from table C.
The date column and the revenue are in table C. But table B is connected to table C through company name and not department name. Same departmentname might exits in several company names, so probably some kind of distinct needed.
Tables are connected like this: Table A to B through departmentname. Table B to C through company-name.
How do I do to correctly aggegate the revenue per each department? I have tried with different aggr expressions without succeding.