Pivot table help

[mcorydon]

I noticed that when I click on a cell in my Pivot Table a new worksheet pops up with the requested information (essentially a filtered version of my data source depending on what cell I clicked) is there a way for that information to appear on the same worksheet as my Pivot Table? And if so can I also edit what parts of the data source appear? Any help would be greatly appreciated.

Thank You​

 

[mole999]

I've not tried later than 2007, the original idea was drill to detail which populates new sheets but it does by default return all from the query. Someone may well have developed code to do what you ask, though I have never seen it demonstrated that way