"Cannot Group That Selection" issue with dates in Excel Pivot Table
I am getting the above error when I try and group dates in a pivot table (I want to have "Year" as a filter in the header)
I attach the list of dates and if you open the filter and scroll to the bottom, you will see that a number of dates are shown separately.
I cannot see what is wrong, as they are formatted as Date.
|