March 24, 2011, 6:30 p.m.
posted by raider
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 15–24, cell B13 informs us that we spent $529.75 at Coho Vineyard & Winery during the month of January. Double-clicking B13 reveals the details, as shown on the next page.