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 2008 for Mac: Pivot Tables for Data Analysis show less
please wait ...

Drilling down to the underlying data

One often overlooked aspect of Pivot Tables is that they make it easier for you to locate individual data points. As an example, suppose you have a Pivot Table that summarizes sales over a series of years. If you want to display the data row that provides the value displayed in a Pivot Table cell, double-clicking that cell causes Excel to drill down into the data source and create a new worksheet that contains a copy of the appropriate row. For drill down to work, you must ensure that the proper option is turned on. To do that, click any cell on the Pivot Table and then on the PivotTable toolbar click Table Options.

In the Table Options dialog box ensure that the Enable drilldown checkbox is selected. If it is, click OK and you are ready to go. Drilling down to the underlying data source is simply a matter of double-clicking the cell that you want to display. For example, if I wanted to display the row providing the value for cell D5, I could double-click the cell and have Excel create a...

Drilling down to the underlying data
Video duration: 2m 8s 1h 7m 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 2008 for Mac: Pivot Tables for Data Analysis

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