I am trying to build a table that reports data from 2 separate spread sheets. I need the filtering capability of a pivot table but do not want to calculate the values. I've managed to make the relationship work and can create a pivot table that gives me access to data in both sheets, my issue is how can I prevent the fields from either counting or being summed. I see these frequently but can't figure out how to build one.



Example I have separate sheets for each week They include Manager, agents names (I use the agents name as the key) and data on their performance. I want to display it in a manner that will allow filtering either by Manager, agent or week, and when filtered by agent show data for each week one below the other.

should look like this
J smith Carol White Wk1 4.00 78.00
J smith Carol White Wk2 5.00 14.00
T Jones Mary Lamb Wk1 2.00 9.99

Currently I'm getting this
J Smith Carol White gibberish 9.00 92.00
T Jones Mary Lamb Wk1 2.00 9.99

Could you attach a sample of your sheets? Why not keep all the data on one sheet with a field for Week?