Hi There,
I have a pivot table that pulls data from a source table using a series of filters. But most important of all the filters is the 'Year' filter. Without a date in the 'Period' column of the source data, none of the other data linked to it will be pulled by the pivot table through the 'Year' filter.
I have dates ranging from 2009 - 2014 and up until recently all those dates have been feeding into the Pivot Table. But since the start of the week the 2009 -2011 dates and 2014 dates are no longer being pulled by the table.
I've tried and checked everything known to me. Are there any suggestions people can give me to trouble shoot this?
I cannot share the data source as it's highly sensitive information.
Any help would be much appreciated.
Rgds,
Oscar.
Bookmarks