I´ve a problem with one of my pivot table. I can´t really post the excel since it contains sensitive information but i´ve attached an image of the problem.
The problem is that dates from my raw-data sheet is displayed twice in my pivot filter section. There is 10 cells with information but 20 visable in the filter section, and its the exact same date but with two different formatting.
I can´t reproduce the problem in a blank new document but I can reproduce it in a new pivot table in the same document.
I´ve tried replacing the raw-data, automatically, manually writing in the dates, using text to columns function but nothing works. I do have 4 other pivot table, in the same document thats working as intended but they aren´t referring to "Close Date". I have also tried pasting the raw-data from my existing document into a brand new but I can´t reproduce the problem that way either.
I´m out of ideas of where the problem is. Do you have any suggestions of where to look?
//Thanks
The problem is that dates from my raw-data sheet is displayed twice in my pivot filter section. There is 10 cells with information but 20 visable in the filter section, and its the exact same date but with two different formatting.
I can´t reproduce the problem in a blank new document but I can reproduce it in a new pivot table in the same document.
I´ve tried replacing the raw-data, automatically, manually writing in the dates, using text to columns function but nothing works. I do have 4 other pivot table, in the same document thats working as intended but they aren´t referring to "Close Date". I have also tried pasting the raw-data from my existing document into a brand new but I can´t reproduce the problem that way either.
I´m out of ideas of where the problem is. Do you have any suggestions of where to look?
//Thanks
