ExcelBanter - Pivot table pulling wrong value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot table pulling wrong value (https://www.excelbanter.com/excel-discussion-misc-queries/39265-pivot-table-pulling-wrong-value.html)

RestlessAde

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

cs02000

If the data is internal to te workbook, could you send me a copy ? I'd love to see it

Gwladys

I'm having this exact problem. The result should be 708 but the pivot table is showing 7082. There are no 7082 figures anywhere in my workbook.

All times are GMT +1. The time now is 07:38 PM.