View Single Post
  #1   Report Post  
Mr. Moose
 
Posts: n/a
Default Setting default pivot table field setting to "sum"

When I drag fields into a pivot table, the field setting is automatically set
to "count". Is there a way to change this to default to "sum" so I don't
have to go into the Field Settings... dialog for every single blasted column
of my pivot table?

Thanks.