Duplicate Values in Pivot Data Source

[Kheldar]

Hello,
I'm using Pivot Table and Slicer to filter data from a raw data source. Our employees work rotating shifts. Between those shifts there are overlap hours. I created a file to track their performance during those 9 hours of shifts.

Morning shift: 08:00 - 17:00
Mid Shift : 16:00 - 01:00
Night Shift : 23:30 - 08:30

I'm using Slicer to select between shifts.

Our tool provides the raw data I need without separating shifts. So for overlap hours (16:00 - 17:00) we get duplicate data resulting in employees appearing in both morning and mid shift in the Pivot Table. What I want is to Excel to ignore the second data set for duplicate entries. Is this possible? Or is there any other way?

Am I clear enough? If not I can provide more info.

I'm attaching the excel file I'm working on for you to see what I'm doing.

Look at the Employee 1 only on Mid and Morning Shift. Employee 1 should only appear in Mid shift. I added the mid shift first and morning second. don't let that confuse you. The raw data source doesn't include shifts and dates. They will be added manually.

Daily Performance Tracker - Template

 

[Fluff]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Duplicate Values in Pivot Data Source
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.