I have two identically constructed Pivot Tables feeding two different Pivot charts. The source data is the same. I added date filters to both Pivot Tables. When I click the Date Filter in one Pivot Table I get the first screen grab and the other Pivot Table gives me the second screen grab. Why would one Pivot Table show all the dates in the year when there are only 14 dates in the source data?
Screen grab 1.png
Screen grab 2.png
Screen grab 3.png
Bookmarks