» Grouping the Date Field by Days, Months, Quarters, and Years in Excel 2007
CATEGORY - Excel Pivot Tables
VERSION - Microsoft Excel 2007
To Group the Date field by days, months, quarters, and years: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:
- Investing in Real Estate, Fourth Edition
- Yes, You Can Time the Market!
- Definitive Guide to Excel VBA
- How to Use Financial Statements: A Guide to Understanding the Numbers
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
No comments have been submitted.
