Forum Discussion
Pivot Table group by month
I am trying to group the columns of my pivot table by month, but when I right click on the date to to group I get a message saying "Cannot group that selection." I have made sure that the source ...
It's normally something stored as text or some blank rows.
look at the column filter, anything there that isn't a date should be easy to spot.
If there are any blank cells, I won't be able to group by month, correct?