How do I create a report that works like a pivot table but does not calculate values
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
|