Hi,
Working in excel 2007. I have set up a pivot table to view sales figures.
I download the data from an sql server and then have to run a text to columns operation so that the date is in the correct format and an can be sorted.
When I built the pivot table from scratch, when I chose to filter by 'Creation date' there was no issue and I could select data from this year, last month, this week-no problem. I test once or twice pasting in the data and seemed to have no issue. When i tried this week, the date filter is no longer possible, I can now just see label filters.
I have tried, formatting the source data in other ways but to no avail. I can filter the souce data by date with no issue but for some reason the date filters are not working on the pt.
Please help.
Working in excel 2007. I have set up a pivot table to view sales figures.
I download the data from an sql server and then have to run a text to columns operation so that the date is in the correct format and an can be sorted.
When I built the pivot table from scratch, when I chose to filter by 'Creation date' there was no issue and I could select data from this year, last month, this week-no problem. I test once or twice pasting in the data and seemed to have no issue. When i tried this week, the date filter is no longer possible, I can now just see label filters.
I have tried, formatting the source data in other ways but to no avail. I can filter the souce data by date with no issue but for some reason the date filters are not working on the pt.
Please help.
