View Single Post
 
Old 03-08-2016, 08:04 PM
elizbeth6339 elizbeth6339 is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2016
Posts: 1
elizbeth6339 is on a distinguished road
Question 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
Reply With Quote