DrillDown in Microsoft Excel
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)
Drilling down the data into large amount of data in a PivotTable will always remain a time taking process as it involves collapsing, expanding and filtering.When we work on pivot table to make a summary of the data, each number in the Values area represents one or more records in the pivot table data source.We can create a list of the related records with Show Details feature on a new worksheet.
In this article, we will learn drilling down the data with pivot table in Excel. Drill down feature is available in Excel 2007, Excel 2010, 2013.
Let us take an example:
If your boss asks you to show any particular field details immediately then you can use Show Details feature of pivot table. In this way, we can use drill down feature of Excel to save our precious time. A new sheet is automatically inserted with an itemized data list showing all rows included in the selected cell.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.