Pivot table - drag field in layout

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

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

Default calculation for data fields in Pivot Tables? 1
pivot table - dragging fields 2
Changing Default Function in Pivot Tables 1
Pivot table question 2
pivot table data field defaults to COUNT, would like it to default toSUM 2
Pivot (Data Items "Count" vs "Sum") 2
Pivot Table Field Settings Default value 2
Pivot table - value field settings - default? 2

Back
Top