Forum Discussion
Grouping Date/Time Data in a Pivot Table not working
I am trying to follow the instructions as outlined here to group by hours: https://www.extendoffice.com/documents/excel/4822-excel-pivot-table-group-by-hour.html The issue is that when I right c...
Detlef_Lewin I had previously checked this link and the solutions and none of them worked for me. I tried reformatting the data in the original raw data and now I have where it says it cannot group that selection. I confirmed the Date column on the original raw data is formatted as mm/dd/yy hh:mm.
Detlef_LewinIt is attached.
griam01 , check your source data formatting
