value problem in a PivotTable in Excel 2010
Posted on 2014-01-07
I am currently working on an excel file that I created (version 14.0.7106.5003 32bit, office pro plus 10 pack) and am having a big problem with my PivotTable.
The PivotTable is on the "EDIT" sheet and refers to the table in sheet "base".
filtering the report "CLIENT" appears inconsistent values.
Example: If I filter "CLIENT" with "VALLAURIS - ANTIBES COMPTABILITE GESTION" result displays the "CLIENT" with "SAEC".
Update the PivotTable does not solve the problem and this problem is present on several filter "CLIENT".
Can you help me find the origin of the problem and explain how to solve it?