» Creating PivotTable in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
Rules for Organizing the Source Data to use in a PivotTableThe rules for organizing a List to create a PivotTable report are as follows:
The List can have only one header row.
All cells in the header row must contain unique text.
The List cannot have subtotal rows, blank rows, blank columns, or a row containing totals under the List.
It is highly recommended to define a Name that automatically updates its range reference for the List,
read more.
Book Store:
Recommended Books:
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Microsoft Windows XP Inside Out
- Absolute Beginner's Guide to Microsoft Office Excel 2003
- Windows XP All-in-One Desk Reference For Dummies
- Treason: Liberal Treachery from the Cold War to the War on Terrorism
No comments have been submitted.
