PivotTable Month Groups Article
|May 7, 2015||PivotTable
Did you know that PivotTables can automatically group date fields by month? And by quarter and year? This date group capability makes it easy to summarize data in monthly columns without writing a single formula. Check out my recent California CPA Magazine article for the details.
- Publication: California CPA Magazine
- Author: Jeff Lenning CPA
- Date: May 2015
- Article: PivotTable Month Groups
Excel is not what it used to be.
You need the Excel Proficiency Roadmap now. Includes 6 steps for a successful journey, 3 things to avoid, and weekly Excel tips.
Want to learn Excel?
Access all Undergrad and Masters lessons with a Campus Pass or CPE Pass. Includes on-demand training plus live office hours.
Hi Sir, i am your fan of your site. I am learn may think of your site, one think or tell me if i group date field in year and quarter in india accounting year start Apr, this is Qtr 1 but excel pivot table so Qtr 2 how to solve this problem Qtr2 to change qtr1.
There are a couple options that come to mind. One is to manually rename the labels by typing Q2 into the default Qtr1 cell. This label change is retained on refresh. Another way to do this is to define your own quarter groups, rather than using the built-in calendar year groups, by using a mapping table. This approach is discussed here:
Hope these ideas help!