Pivot Table - Drill Down data is same sheet

[Access]

Hi, I want the drill down data to appear in a single sheet in the order in which I double click the values in the PT. Now when I double click a value in PT separate sheets get opened in the same workbook. Any help is much appreciated.

 

[Debraj]

Hi..

Pivot table also drill down the data in same sheet.. in the order in which you double click..
BUT only in ROW FIELD..
It will also ask you.. according to which other row .. you want to drill down..

Obviously, double click in value filed.. need to show complete data, from where the calculation occurred..

BTW.. if you dont need any calculation.. you can use Outline feature of EXCEL..