Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table not summing
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table not summing
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. "japc90" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table not summing
On Dec 15, 5:16 pm, "HansM" wrote:
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. "japc90" wrote in message ... 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.- Hide quoted text - - Show quoted text - AMAZING!!!....Thank you! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing data in a Pivot table | Excel Discussion (Misc queries) | |||
summing function in pivot table in column wise ?? | Excel Worksheet Functions | |||
Total Not Summing Correctly on Calculated Fields in Pivot Table | Excel Discussion (Misc queries) | |||
pivot table column summing | Excel Discussion (Misc queries) | |||
pivot table column summing | Excel Discussion (Misc queries) |