Filtered pivot data not displaying correct data

I have built a pivot report and then inserted slicers. When I click on a slicer, the data is filtered on the slicer sheet and also reflected on the pivot. However, if I click on the filtered pivot count, I expect the new sheet that opens to only show the filtered data. Instead, all data is displayed.

For example: My pivot counts patients assigned to a doctor. Lets say doctor A has 100 assigned patients. When I click on a slicer field to only show those patients assigned in 2012, doctor A's count drops to 50. When I view the pivot sheet, the count is 50 there as well. This is correct so far. However, when I double click on the 50, the subsequent sheet that opens displays all 100 patients.... I'm expecting only the filtered 50 to show as is what typically happens when you double click on filtered pivot data. Any ideas what could be causing this?

Thanks!

argthe3rd,

Figured it out - In order for you to see just the sliced (filtered) number of rows, you must have the Column you use on the Slicer either as part of the Column in Row box or on the filter box. I added it in the Filter box and hid the row - now if I narrow the value in the Pivot table using the Slicer it shows just those rows with the value narrowed down by the Slicer. (in your example - add Doctor as part of the Filter and then if you click on the 50, it will just show the 50 patients).

Cheers!!