Excel Pivot Table Date Grouping Error

With time grouping relationships across time related fields are automatically detected and grouped together when you add rows of time fields to your pivottables.

Excel pivot table date grouping error.

Reasons for error in excel pivot table date grouping. For example you may have entered text such as n a if a date was not available when the data was being entered. The time grouping feature is new in excel 2016. In the right click menu click ungroup.

Since excel 2016 when you drag a date field to a pivot table pivot table row the dates are automatically grouped by months instead of showing each date. I have tried the text to columns and it changes the dates to numbers i have experienced this problem with most of my data dumps and i need learn how to fix the grouping issue. Add the date field to the pivot table. This excel tutorial explains how to group dates and ungroup month in excel pivot table to prevent auto grouping of pivot table in excel 2016.

Once grouped together you can drag the group to your pivot table and start your analysis. However you get an error message cannot group that selection when you try to group the dates. If you try to group pivot table items in excel you might get an error message that says cannot group that selection for older versions of excel if you had a problem grouping pivot table items it was usually caused by blank cells or text in number date fields. Pivot table won t allow you to group dates and you will get an error.

We can equally sort our dates from the most recent sales to the oldest and vice versa. The most common reason for facing this issue is that the date column contains either. Immediately press ctrl z to undo the automatic date grouping. How to sort pivot table dates.

In excel 2007 you added a date field to the pivot table s row area and you want to group the dates by year. If you re using excel 2013 or later there s another reason that might prevent you from grouping pivot table items. When you try to group dates in an excel pivot table or other pivot table items you might get a pivot table error cannot group that selection in excel 2010 and earlier versions that error was usually caused by blank cells in your source data or text in the number or date columns. If even one of the cells contains invalid data the grouping feature will not be enabled.

Add the date field to the pivot table. To do this we will right click on any of the dates select sort and lastly click newest to oldest figure 6 how to sort pivot table date. At any time right click on any of the date field items or headings. The grouped fields are removed and the original date field remains in the pivot table.