This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Attached is the exercise solution
Here's how I did it.
I think this exercise is good for tax users.
Solved Practice x 2
Before joining the Emp details, I have used summarize to remove the duplicates.
As Employee_ID "787" is appearing in two rows, therefore I have taken "Sum" in summarize.
Practice Exercise #2