Pivot Table not summing

J

japc90

I am attempting to create a pivot table. Everything is working fine
except for the field I want to insert in my "Data" section. The column
this field is pulling from contains numbers and I want the pivot table
to sum these numbers. Instead, it defaults to count and when I switch
it to sum it shows zeros. All help is greatly appreciated.
 
H

HansM

It could be that the numbers are not numbers. In the data sheet, can you
total the column? Maybe you have to turn it into values by adding a column
=value(text_column) and then use that column.
 
J

japc90

It could be that the numbers are not numbers. In the data sheet, can you
total the column? Maybe you have to turn it into values by adding a column
=value(text_column) and then use that column.






- Show quoted text -
Click to expand...

AMAZING!!!....Thank you!
 

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 Shows Only Zeros 3
Average of % in pivot table 1
Pivot Table 2
Pivot table questions 1
about pivot table 1
Need the grand total pivot table filtered worksheet? 1
default pivot tabel from count to sum 1
Pivot Table 1

Top