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.)