Hi ti all:
I got a pivot table getting data from an odbc SQL server.
The first column is agent ID, the second one is supervisor, the third
is agent name and the fourth one is the call volume. Here is an
example:
AgentID Name Supervisor Call volume
01 Nick Super1 10
Nick Super1 4
02 John Super1 5
03 Marie Super2 8

If I do a Vlookup for agentID 01, I'll get call volume of 10 but in
fact it's 14 since Nick got 10+4.
I can't combine a sum with vlookup with the name since Nick is not the
only name showing in the pilot table.
I need to find a way of calculating call volume of agentid 01 untill I
get a different agentid in a vlookup.
Thanks a bunch!