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:
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
