I have a pivot table that is showing data that is not on the source data? If I go to row heading 'date' it shows dates that do not even exist. How can I shut this off? I need to have 'show the items with no data' clicked...but why is it showing dates that are not there? anyone, please help me out!
Kharyat
Kharyat