Employee Timesheet Pivot Table

[jsmucker24]

Introduction
Good afternoon, I have a workbook containing 3 sheets of data.

1. 1; "Employee" containing Employee Name; Date Hired; and Years Worked;
2. 2 "DataTable" containing time data, Date, Start Time, End Time, etc..
3. 3 contains a Pivot Table in which I need to pull together a report, containing
   1. Employee Name,
   2. Total Hrs,
   3. Average Days worked pr week,
   4. Years Worked
   5. Pd Vacation Days Earned (Years Worked + 5)
   6. Year End Bonus earned ( (Years worked * 100) + (Average Days * 100)

Issue
As you see I need to add Calculated Fields to my pivot table to get some of my results. The only one that I am stuck with is the Years Worked value, (which is in the Employees Table, outside of the main data source). I have tried adding a column with a vlookup function in the datatable and then showing the value as Min or Max but when I add calculated fields, Excel wants to calculate based on the underlying data which is the sum of "Years Worked".
Any ideas on how to work around this? or how to restructure my data?

PS; The user will frequently be adding new employees to the list.

 

[jsmucker24]

Is anybody home??????

 

[alansidman]

If you bring your tables into Power Pivot - Data Model (part of your 360 subscription), you can join the tables on a common field and then have the data available for your pivot table.