» 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:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
- Special Edition Using Microsoft Excel 2002
- Dictionary of Finance and Investment Terms
- Excel 2002 For Dummies®
- Retire Young, Retire Rich
No comments have been submitted.
