Analyzing Microsoft Excel 2010 Data with PivotTable Reports

  • 8/31/2010

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: