View Single Post
  #1   Report Post  
RestlessAde
 
Posts: n/a
Default Pivot table pulling wrong value

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