Home > Sample chapters > Microsoft Office > Excel

Analyzing Microsoft Excel 2010 Data with PivotTable Reports

Displaying the Details Behind a Data Value

If you double-click any PivotTable value that represents a summary calculation, Excel displays the details behind that calculation on a new worksheet. For example, in Figure 23-26, cell G11 informs us that we spent $681.21 at Coho Vineyard during the month of June. Double-clicking G11 reveals the details:

httpatomoreillycomsourcemspimages1741582.png