I have created a pivot table but when I drill down, it shows all of the data and not just the selected data.

Enable drill down is selected in the options.