2007 MicrosoftВ® Office System Inside Out (Bpg-Inside Out)

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.