| 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) | |||
Hybrid Mode
