I am new to Tableau and am running into a problem with calculating between worksheets when working with multiple connectors. Basically, I have one CSV with data on how productive our employees are. I have another CSV with data on how productive they should have been. I want to divide those numbers so I can see what % each employee is. Currently, I'm downloading the information from Tableau back into Excel so I can make this calculation. Is there a way I can do this all in Tableau?
Worksheet 1 (from data set 1)
Employee Items Sold
Worksheet 2 (from data set 2)
Employee Projected Sales
I want to be able to show that Adam reached his goal, Bob was 66% and Charlie was 10%.