» Getting Drill-Down Details
CATEGORY - Excel Pivot Tables
VERSION - All Microsoft Excel Versions
In the PivotTable report, select a cell in the Data area for which you want to get drill-down details and double-click. A new sheet is automatically inserted with an itemized data List showing all rows included in the selected cell.
Example: Double-click cell B7, see screenshot.
Book Store:
Recommended Books:
- Business Analysis with Microsoft Excel (2nd Edition)
- Business Plans Kit for Dummies (With CD-ROM)
- Windows XP All-in-One Desk Reference For Dummies
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- The 22 Immutable Laws of Marketing : Exposed and Explained by the World's Two
- Analysis of Financial Statements
No comments have been submitted.
