Pivot Table not summing

  • Thread starter Thread starter japc90
  • Start date Start date
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.
 
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.
 
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
Pivot Table Calculated Field - Sum/count 1
about pivot table 1
Pivot (Data Items "Count" vs "Sum") 2
Using text values in Pivot Tables 5
Average of % in pivot table 1
Headings for Sum in Pivot Table. 5
Pivot Table 1

Back
Top