Pivot Table - Duplicated Values Giving Inaccurate Results

Hello,

I am working on a data log that is being displayed in a PivotTable that will be sheet protected. I want to be able to have the user filter the pivot table by a "Report Filter" and some vba macros (which are all working perfectly). However, I want to be able to display the 'Location' of a sample and have the user filter by 'Location'. So in the data for the Pivot Table, I created an extra column that was labeled 'Location2' and had it equal to 'Location'. Generated the data and refreshed the pivot table.

The problem arises when I try to filter by the Report Filter of "Location2" and I get very inaccurate results. After lots of playing around, I finally added the "Location2" to the Row Labels with "Location" and had them side by side. The crazy thing is that it is showing different results. I go back to the sheet that has the duplicated column of Location and everything is exactly the same.

Has anybody ran into this problem? Does anybody have any suggestions what could cause this. (Keep in mind, there are currently no macros or VBA in play here, it is straight up populating the data for a pivot table, Creating a pivot table, and the data doesn't jive to what the data for the pivot table displays.)

Thank you very much for this. I was able to fix it prior to seeing this message. I could not manually create the problem with those numbers but did notice duplicate values for a single value. The data should have all been in 'Text' format but a few of entries were in 'Number' format. Therefore, there was duplicate data for a single filter and the macro would error because it didn't know which single filter it should pick. I ended up just doing a simple '=ISTEXT()' and going to all the 'Falses' and making them back to 'Text' format. I then had to clear all fields and recreate the pivot table to completely fix this issue.

Everything is working now, thank you very much for your input and sorry for the late response.