» Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
1. Drag the Date field to Row Labels area in PivotTable Field List dialog box (this area must contain a Date field only).
2. Select a cell in the Date field, right-click and select Group.
3. In the Grouping dialog box, select Days, Months, Quarters or Years.
CAUTION!!! If the message Cannot Group that selection appears, drag the Date field out from Row Labels, go to the source data, check the date column in the source data for empty cells or for dates that are not in a date format, fix their format, then select the PivotTable report, refresh it, drag the Date field to Row Labels again and try Group the field again.
Book Store:
Recommended Books:
- Millionaire Real Estate Mentor : The Secrets of Financial Freedom through Real Estate Investing
- Business Plans For Dummies®
- Understanding Financial Statements
- Rich Dad's Guide to Investing: What the Rich Invest in, That the Poor and the Middle Class Do Not!
- Microsoft Windows XP Registry Guide
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
No comments have been submitted.
