Hi,
My pivot table is working fine, but it has been really bugging me why I can't find the setting/option to disable this. I have data that shows the number of incidents handled per month, and the pivot table does a great job to summarize the data for this purpose. My dataset has entries with dates starting with 10/1/14 through the end of August 2016. When I create a pivot table, there is always a blank column that represents dates <10/1/2014.
Since I know my data has no entries from before 10/1/14, why does excel insist on adding this column? If I actually had entries from earlier days, excel's date groupings would just add that data in the correct way with a new column, so I don't see how this is ever helpful.
Thanks gurus.
2016-09-27 09_42_50-Microsoft Excel - PRD Service complaints raw data.xlsx.png
Bookmarks