Pivot table - drag field in layout

L

Lily

When I create a pivot table by using wizard, I drag fields to the diagram. For fields contained numbers, sometimes it appears to be sum of xxx and sometimes it defaults to be count of xxx. I know I can change it by double clicking. I'm not sure if there is a way to default it to count or sum.

Thanks, Lily
 
D

Dave Peterson

If all the data in that field are numbers, then you'll get Sum.

If any of the data is text (or blank), then you'll get Count.

I don't think you can change this behavior.
 
Top