Forum Discussion
Group
How can i group this type of data in my pivot( weekly per hour )where dates and times are combinedined together in same cells in the raw data When i try it says cannot group selection , its an ...
When i try it says cannot group selection , it's an extensive list
This error suggests one or both of the following is true:
1. Those dates are texts
2. There's non-dates mixed with the text
From the screen capture, my guess is it's #1.
Convert numbers stored as text to numbers - Microsoft Support
- If you want to group for dates in a pivot table, dates must be the only data type in the field.
will check thanks