Tips: To apply this PivotTable Special Time Grouping feature, firstly, you should download the Kutools for Excel, and then apply the feature quickly and easily.Ĭlick Kutools Plus Pivot Table PivotTable Special Time Grouping, see screenshot: 2. Excel Pivot Table Group By Month Download The Kutools If you have Kutools for Excel, with its PivotTable Special Time Grouping feature, you can quickly group date by fiscal year, half year, week number, day of week, half an hour or specific minutes as you need. Now you can see the data is grouped by month and year as following screenshot shown: Group date by half year, week number or other specific dates in pivot table With the above method, you can group date by month, year, quarter quickly, but, sometimes, you may want to group date by specific date, such as fiscal year, half year, week number and so on. See screenshot: Tips: In this Grouping dialog box, you can also select the Months, Quarters, Years separately for grouping the date by month, quarter or year as you need. In the Grouping dialog, select the grouping criteria from the By list box. Then go to the pivot table, right click anywhere under the Row Labels head, and select Group. In Excel 2016 and later versions, it will automatically group the Date into Years and Quarters), see screenshot: 4. In the Create PivotTable dialog box, check the option you need in the Choose where you want the PivotTable report to be placed section.Īnd in the PivotTable Field List pane, drag the field to the areas you need, and make sure the Date label is in Row Labels list. Excel Pivot Table Group By Month Download Kutools For.Excel Pivot Table Group By Month Download The Kutools.Our short video course, Core Pivot, walks you step-by-step through the most important features of Pivot Tables. Pivot tables are easy to create but hard to control. You can group customers by total sales, group employees by their time at a company, group weather data by temperature – the list is endless. You can use this same approach to group numeric data in many useful ways. When you click OK, you’ll see your data neatly grouped by age at 10 year intervals. For this example, we’ll group by 10 years. When the Grouping dialog box appears, enter any interval that makes sense in the “By:” input area. To group results by age, right-click any value in the Age field and choose Group from the menu. This is easily done using the grouping feature built in to pivot tables. We don't care that five 20-year-olds voted for Option B – we want to see voting results by age ranges, like 20-29, 30-39, etc.
At this point, our pivot table looks like this:Īlthough this pivot table is interesting, it’s not very useful, since the automatic grouping by actual age is too granular. In the example below, we also renamed Grand Total to Total. Next, add the field Age as a Row Label, and the field Vote as a Column Label. To get started grouping the data by age, first create your pivot table normally. Your data might look something like this: To illustrate, let’s assume you have a list of voting results that includes voter age, and you want to summarize the results by age group. For example, you can also use a pivot table to group data by numbers – summarizing data by age range, price range, or any numerical range that makes sense for your data.
Many people stop with this basic automatic grouping, but pivot tables can also group data in more sophisticated ways. In this case, with the department field added as a row label, the pivot table neatly breaks out a count of employees by department, with a new row for each department that appears in the source data. For example, you might use a pivot table to group a list of employees by department. Any field added as a row or column label is automatically grouped by the values that appear in that field. One of the most powerful features of pivot tables is their ability to group data.