Debra Dalgleish has some very nice notes about pivottables at her site:
http://www.contextures.com/
http://www.contextures.com/tiptech.html

She has an addin that can change Count's to Sum's:
http://www.contextures.com/xlPivotAddIn.html



On 01/11/2012 08:47, wesley holtman wrote:
Hello,

Does anyone know a way within XL to change multiple data fields (ex.
from sum to count) at the same time? If not, could someone please help
me start to develop a macro to do so?

Thank you in advance!

--
Dave Peterson