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 Counting Text Data 0
Pivot Tables 0
VLOOKUP a Pivot Table Filter 0
Pivot Table Shows Only Zeros 3
Filtering by group in pivot table 0
Pivot Table Calculated Field - Sum/count 1
Excel 2007 vlookup with Pivot table 0
Slicers and Calculated Items in Pivot Table 2

Top