Also join on the Employee name (3rd condition). You have just joined date and manager. This is giving you total sales.
if possible share the entire table structure for both the tables? (I don't need data)
This is just to see if you have missed any other column.
1 of 1 people found this helpful
Please find the attached workbook and excel data to check if you are missing anything from this steps.
after blending please check if you have enabled this links else you won't get the desired output as per you have defined the relation. I have highlighted the links that you need to ensure.
Let me know if this helps.
Thanks and Regards,
Hi Ashish, after grouping, I had to re-enable links again. Thanks!