A client's pivot table always gives 'count' in the data area even on a
numeric field. Is there any way to set the default to always show 'sum'? i
thought this was the default. Any ideas why this is happening?

Thanks

Diane