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.