I encountered a similar problem. I found that in a pivot table you can't
give a field the same name as one of the columns from your original data
set. Change the name slightly and you should be able to remove the "Sum
of". The problem that I'm having, however, is that even if I change the
name, the sum function remains - summing my data where I don't want it
to. If you can help me on that, let me know.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=545112