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 22-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.

image from book



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net