Courses / PivotTables & PivotCharts
25. Drill down / Show Details
Double-clicking a summarized value to create a new sheet that lists the underlying rows that make up that value.
PivotTables and PivotCharts (Excel)
Drill down / Show Details
Double-clicking a summarized value in a PivotTable to open a new worksheet that lists the underlying source rows that make up that subtotal.
"I need to see the actual sales records behind this total without rebuilding a filter by hand."
Drill down (Show Details) creates a new sheet containing the raw rows from the PivotTable's source data that contributed to the selected value, so you can inspect or export the exact records.
"I need to see the actual sales records behind this total without rebuilding a filter by hand."
Drill down (Show Details) creates a new sheet containing the raw rows from the PivotTable's source data that contributed to the selected value, so you can inspect or export the exact records.