Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table "sum of "-field is not working
Within the pivot field i want to see the sum of a field (external list), but
the function returns "0". "Count of" works fine and correct. The field is formatted to number format. Any suggestions ? -- gohlensc |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table "sum of "-field is not working
Even though the field is formatted as numbers, Excel is probably seeing
the dates in the source table as text. There are some techniques here that you can use to convert the text to dates, so they can be summed correctly: http://www.contextures.com/xlDataEntry03.html gohlensc wrote: Within the pivot field i want to see the sum of a field (external list), but the function returns "0". "Count of" works fine and correct. The field is formatted to number format. Any suggestions ? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
pivot table "sum of "-field is not working
Hi Debra,
thanks for that hint, but didn't help. To make sure that the formats are correct, I tried the function "Sumif", which works perfectly. Do you have any other idea? Thanks in advance. Gabi -- gohlensc "Debra Dalgleish" wrote: Even though the field is formatted as numbers, Excel is probably seeing the dates in the source table as text. There are some techniques here that you can use to convert the text to dates, so they can be summed correctly: http://www.contextures.com/xlDataEntry03.html gohlensc wrote: Within the pivot field i want to see the sum of a field (external list), but the function returns "0". "Count of" works fine and correct. The field is formatted to number format. Any suggestions ? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double "calculated field' for Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table - Remove "sum of" in data field | Excel Discussion (Misc queries) | |||
Don't want the "All" option in the Drop Page Field of a pivot tabl | Excel Discussion (Misc queries) | |||
Pivot Tables - How can I "reset" the selections in "Row Field"? | Excel Discussion (Misc queries) | |||
"Show Field List" in Pivot Table Toolbar doesn't work | Excel Discussion (Misc queries) |