Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table data incorrect
I have created a very simple pivot table from an Excel 2000 list. There are
no blank rows and I haven't changed any of the default settings. I am only trying to sum a value. Does anyone know why some of my rows of data wouldn't be calculating correctly? The Row headings show but either have a zero value or only sum some of the data. Thanks for your help. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot table data incorrect
I figured out that a couple of the fields had incorrect data typed. Thank you.
"Alex" wrote: I have created a very simple pivot table from an Excel 2000 list. There are no blank rows and I haven't changed any of the default settings. I am only trying to sum a value. Does anyone know why some of my rows of data wouldn't be calculating correctly? The Row headings show but either have a zero value or only sum some of the data. Thanks for your help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect total of calculated field in pivot table | Excel Discussion (Misc queries) | |||
Pivot table formula (calculated field) result is incorrect | Excel Worksheet Functions | |||
Pivot Table data incorrect | Excel Discussion (Misc queries) | |||
Pivot Table sum incorrect | Excel Discussion (Misc queries) | |||
Incorrect totals in Pivot Table | Excel Discussion (Misc queries) |