Slicer filters don't work properly

I run a daily report in SAP that gives me all the hours worked the previous day.
I incorporate the data into a YTD Raw Hours tab in a workbook which currently exceeds 50,000 rows for approximately 250 employees.
From that raw data I have various pivot tables in several sheets within the workbook.

From one particular pivot table I had added various slicers - date / time type description / org. unit number / etc, etc

If for example, via the slicers, I ask for Hours Worked on a specific day, I get the Sum of Hours in the pivot - 80 - which tells me that 10 people worked an 8 hour shift that day.

When I double click on the 80 sum hours cell I expect to see the names and details of the 10 employees that worked that day. And I do but I also see every single other shift/SAP entry they've had hours for YTD.

So, for 10 employees working on the same day my expected row number of 10 actually out to be more than 1200 rows because it includes every single date YTD for each of the 10 employees.

What is the point of Slicers if the filters you choose don't work? Or maybe I am missing something?
http://www.excelforum.com/showthread...40#post4080340
If anyone has any ideas I would really, really appreciate it.

Thanks, Brenda

Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.