Pivot table pulling wrong value

G

Guest

Hi,

I have pivot tables that seem to pull the wrong value from my data series.
The value in question is a string describing the name of a report "Motor
Drives - WW - 2005". My pivot table pulls this value and adds the value 2 to
it. E.g. "Motor Drives - WW - 20052". When I drill to detail, the correct
value is shown.

Is this an Excel bug? Has anyone else encountered it and know how to fix this?

Thanks,
Ra
 

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

Pivot table help 2
How to refresh drop-down list of pivot table 3
Consolidated Pivot table 1
Pivot table - value field settings - default? 2
Pivot Table blank rows 1
drill down worksheet placement (pivot tables) 1
Value not showing in pivot table 7
Pivot Table Page Break Refresh Problem 0

Top