Pivot table - drag field in layout

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table question 2
pivot table data field defaults to COUNT, would like it to default toSUM 2
Changing Default Function in Pivot Tables 1
Pivot Table Field Settings Default value 2
Pivot table - value field settings - default? 2
Pivot Table Page Layout Questions 1
default pivot tabel from count to sum 1
Pivot table wizards 2

Top