» Getting Drill-Down Details in Excel 2007
To get full drill-down details:
In the PivotTable report, select a cell in the Values area for which you want to get the drill-down details and double-click the cell.(or- double click the cell in the Values area Details)
A new sheet is automatically inserted with an itemized data list showing all rows included in the selected cell.