Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Item Displaying Incorrect Value?
We have a pivot table, which has Project as pivot field 4.
The Project pivot field has 3410 pivot items, of which number 842 is misbehaving. The project value for this item is 10537 , and when you drill to detail, that's what you get. Correctly. However, the .Name , .Caption, and .Value properties for this PivotItem all say 616 . In the pivot item drop down list, it's sorted right where 10537 should be, but it says 616 . Thoughts on why/how this would be? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Item Displaying Incorrect Value?
best I can tell, someone must have manually typed the 616 accidentally, and
the pivot table is set to accept/display that. I guess. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Incorrect values on pivot chart???help!!! | Charts and Charting in Excel | |||
Pivot table data incorrect | Excel Discussion (Misc queries) | |||
How do I create a graph displaying two parameters for one item | Charts and Charting in Excel | |||
Pivot Table sum incorrect | Excel Discussion (Misc queries) | |||
Displaying an excel file as an active desktop item? | Excel Discussion (Misc queries) |