Pivot Item Displaying Incorrect Value?

M

mark

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?
 
M

mark

best I can tell, someone must have manually typed the 616 accidentally, and
the pivot table is set to accept/display that.

I guess.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculated Item in Pivot table 1
pivot table pull down filter 2
Pivot Table - Problems when using Calculated Item 1
Macro Help in Pivot 2
Can I add an item to a PivotCache with VBA? 4
GETPIVOTDATA....Excel 2000....Desperation! 1
Hide all PivotItems except for a specific Item 1
Problem with Calculated item in Pivot Table 1

Top