I have in the attached file a table of date + time
I create a pivot and want to group the dates for month and year and it shows me an error message
What is the solution?
Thank you very much for your response
Leah
Hi Leah,
Thanks for sharing your sample data.
If you add a Filter to column A and then click the Filter drop down you can see that some of the dates are not grouped. This is because these dates are in a text format.This data starts on row 87 through 545 (note, it may not be consecutive, I didn't check).
You must fix this format for Excel to be able to group the dates in both a Filter or a PivotTable. The simplest solution is to:
1. Type a 1 in any empty cell.
2. Copy that cell.
3. Select all of the dates in column A, even the ones that are in the correct format, if it's easier.
4. Paste Special > select radio buttons: Value and Multiply > OK
Your data should now be in the correct time and date format so you can refresh your PivotTable and complete the grouping of the dates.
Mynda
