Pivot Table - Remove "sum of" in data field

Giganews Newsgroups
Subject: Pivot Table - Remove "sum of" in data field
Posted by:  abgmclt (abgmclt.28f0pa_1148647801.2111@excelforum-nospam.com)
Date: Fri, 26 May 2006

Is there a way to modify Pivot Table so that "Sum of, Count of", etc is
not shown.
For example, have Table (& Pivot Chart) show "West Region" instead of
"Sum of West Region"

Thanks

--
abgmclt
------------------------------------------------------------------------
abgmclt's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=34831
View this thread:http://www.excelforum.com/showthread.php?threadid=545831

Replies