Hi,
I've imported a CSV file of expenses with dates in it (please see attached file). From the sheet "Expense.csv" I've created a pivot table "Pivot 1" but can't group the first column "Date" by month. I've recreated the data "Expense.csv (2)" replacing the date column with dates I've made up and it works fine - "Pivot 2" - so clearly the format of the date column in the first sheet is causing the problem. I tried to re-format it using custom date, re-create it using functions but couldn't fix it so the pivot table "Pivot 1" worked.
Can anyone explain what the fundamental issue is?
thanks,
Neil
Bookmarks