Notifications
Clear all
Xtreme Pivot Tables
2
Posts
2
Users
0
Reactions
90
Views
Topic starter
I am trying to group dates in a pivot report. I keep getting a message "Cannot Group Selection". Can anyone help me to fix this.
Thanks
Posted : 25/05/2016 10:57 am
Hi Deepak,
Check your data, there should not be other data types than dates in that column. If your column contains mixed data types (text, numbers), or even blanks, you will not be able to group the dates.
Check also if your dates are really dates (numeric), you might have text strings that looks like dates, but the data type is not numeric.
Catalin
Posted : 25/05/2016 12:15 pm
