From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 24,700 courses taught by industry experts.

Group PivotTable data in different time frames, year, quarter, month, week, and more

Group PivotTable data in different time frames, year, quarter, month, week, and more - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Group PivotTable data in different time frames, year, quarter, month, week, and more

“

- [Instructor] On this worksheet we've got a list over in columns A through G. It's about 900 rows and we've created a pivot table. It's in column I through N. Notice that the date information is day by day by day. That's the way it is in the source data. But you can group date based information in pivot tables in a variety of ways. The green image to the right is a snapshot of an image taken from a pivot table that's based on that same data. We see the grouping by years and months. Off to the right, another kind of grouping by a two week period. And below that, even another kind just by year. We can get there in a variety of ways. And built into pivot table creation is a feature called automatic grouping. You're unlikely to see it as you use and create pivot tables, but when applied with dates, it has some differences. And there is an Excel setting. It's called disabled automatic grouping under Excel options that we might consider changing. So on the file tab, in the ribbon menu…

Contents