» 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:
- Retire Young, Retire Rich
- Microsoft Office XP Introductory Concepts and Techniques
- Learn MS Excel 2002 VBA/XML Programming
- The One Page Business Plan: Start With a Vision, Build a Company!
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
