So I am working on a file for my boss and I created this hypothetical document included https://drive.google.com/open?id=0B3...001aFhmRlN1V2s
The objective is to make it so that the two tables can be joined together to get the pivot table to display the rate for each employee based on the number of hours that they worked. For instance, for Bob's 8 hours spent doing "spring" you would see the rate right next to it ($6) and then next to that column, show how much he gets paid for that ($48).
Instead, I'm getting errors that show relationships between tables may be needed. I know that I could grind this out and do a bunch of nested if functions (unfortunately the actual spreadsheet has hundreds of employees). Any idea on how to solve this problem? I'm not bound to pivot tables as a method, but any way you could help or explain to help would be great.
Thank you!!
Bookmarks