Sum in pivot tabels

  • Thread starter Thread starter CLUPE
  • Start date Start date
C

CLUPE

Hi,

I am experincing a problem when I am draging and dropping to a
pivottable. I would like to have "Sum of" but I get "Number of". When
you drag and drop 15 times it takes a longe time to change.

Is there a way to change all the "Number of" to "Sum of".

Chris
 
Make sure that all the data for that button is actually stored as numbers
and blanks are filled with zeros. Then the default will be Sum of.
 
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

Getting correct labels in Excel pivot 2
Pivot table "Sum of" or "Count of" 1
Pivot table 1
Code problems for pivot table 1
join multiple pivot tables? 1
Sum Function When Formula Produces #N/A 2
Multiple measures in MS Access pivot table-Sigma Value in Row not Column 0
Pivot Table Calculated Fields 4

Back
Top