A former co-worker asked me this question:
I created a pivot table but when I drill down, it shows all of the data and not just the selected data. I'm assuming it is in a setting that is causing the problem but cannot find a resolution. Can you point me in the right direction?
I am not sure...