Drilling down to the underlying data


show more Drilling down to the underlying data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Drilling down to the underlying data

One often overlooked aspect of PivotTables is that they make it easier for you to locate individual data points. As an example, suppose you have a PivotTable that summarizes sales data over a series of years. If you want to display the data row that provides the value displayed in a PivotTable cell, double-clicking that cell causes Excel to drill down into the data source and create a new worksheet that contains an Excel table with a copy of the appropriate row. So for example, let's say that I wanted to see the row in the data source for this PivotTable that provided the value for FirmA 2009 in the month of March.

That's the cell that I selected inside the PivotTable. To do that, I double-click the cell and Excel creates a new worksheet and it shows an Excel table with the entire row providing the data for that cell in the PivotTable. Now this drill-down capability only works for one cell at a time, but it is possible to drill down into a data source even if the PivotTable dr...

Drilling down to the underlying data
Video duration: 1m 44s 3h 43m Intermediate

Viewers:

Drilling down to the underlying data provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...