Hello everyone,
I've never really worked with pivot tables, but what they do is simila
to what I want with one exception. I don't want it to give me any sum
which it seems to be doing automatically. I was able to hide certai
totals, but is there anyway to turn off that particular aspect (th
summing of values). I hope I wasn't too unclear about this. Thanks.
-- Isaa
Die_Another_Day - 14 Jul 2006 20:13 GMT
A pivot table must do some function for you. However it can be changed.
Right-click the data and choose field settings. You should be able to
find something more suitable than sum, I usually use max.
HTH
Die_Another_Day
> Hello everyone,
>
[quoted text clipped - 11 lines]
> I Maycotte's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35604
> View this thread: http://www.excelforum.com/showthread.php?threadid=561558