Hope the data format of both ranges are same. Refer
http://www.contextures.com/xlPivot08.html

If this post helps click Yes
--------------
Jacob Skaria

"Gringarlow" wrote:

I have 2 tables of data, one shows %'s of errors for individual techs, the
other shows details of the techs work that caused the errors. I tried to
build a pivot table using multiple ranges of both table, but can't get the
results I need. I want to show the Tech Name ( Which is a field in both
tables) and the %'s . Then what I was asked to provide was the ability to
click on the name and get the details on a new sheet. I can't figure that
part out.