Analyzing Microsoft Excel 2010 Data with PivotTable Reports
- 8/31/2010
Contents
×
- Introducing PivotTables
- Creating a PivotTable
- Rearranging PivotTable Fields
- Refreshing a PivotTable
- Changing the Numeric Format of PivotTable Data
- Choosing Report Layout Options
- Formatting a PivotTable
- Displaying Totals and Subtotals
- Sorting PivotTable Fields
- Filtering PivotTable Fields
- Changing PivotTable Calculations
- Grouping and Ungrouping Data
- Displaying the Details Behind a Data Value
- Creating PivotCharts
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:
){kind=link}
