» Getting Drill-Down Details in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
To get full drill-down details:In the PivotTable report, select a cell in the Values area for which you want to get the drill-down details and double-click the cell.(or- double click the cell in the Values area Details)
A new sheet is automatically inserted with an itemized data list showing all rows included in the selected cell.
Book Store:
Recommended Books:
- Retire Young, Retire Rich
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- The McGraw-Hill 36-Hour Course in Finance for Nonfinancial Managers
- The Fall of Advertising and the Rise of PR
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
