Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Can you share the screen of the tables?
Is there anything in the table C that states which revenue is under given department?
If the data is just connected the way you explained you can aggregate revenue only by the Company Name and Date Fields.