1 Reply Latest reply on Dec 13, 2017 3:15 PM by Deepak Rai

    How Do I Calculate Grand Totals From Different Worksheets?

    erik.throm

      Hi All,

       

      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?

       

      Generic Example

       

      Worksheet 1 (from data set 1)

       

      Employee     Items Sold

      Adam                   5

      Bob                    10

      Charlie                1

       

       

      Worksheet 2 (from data set 2)

       

      Employee     Projected Sales

      Adam                    5

      Bob                       15

      Charlie                   10

       

      I want to be able to show that Adam reached his goal, Bob was 66% and Charlie was 10%.

       

      Thank you in advance!