PIVOT TABLE WON'T SHOW ALL DATES

Question

Hello,Sorry, I'm new in the pivot table worldplease help me..&nbsp;Pivot table shows only up to nov 9data encoded is already up to dec 20 but it won't showtried the refresh and other things but it wont work..&nbsp;thank you so much&nbsp;&nbsp;&nbsp;&nbsp;

hansvogelaar · Answer

aileenc07
Employee "Andrade F" has been selected in the slicer. Perhaps this employee only has dartes in November?
What happens if you click the 'Clear Filter' button in the upper right corner of the slicer?

aileenc07 · Answer

HansVogelaar&nbsp;&nbsp;she has dates until decwhen i click the clear filter from dateit shows this but it still doesn't show&nbsp;also tried this&nbsp;pls helpthanks

hansvogelaar · Answer

aileenc07 Could you attach a copy of the workbook (remove sensitive information)?

aileenc07 · Answer

HansVogelaar&nbsp;https://ufile.io/4xujniushere it is&nbsp;thanks&nbsp;

hansvogelaar · Answer

aileenc07&nbsp;
Thank you. The source range of the pivot table is PERFORMANCE!$A$1:$U$5795; Row 5795 is the last row of 9 November 2021.
But the data extend to row 6571. If you change the data source to PERFORMANCE!$A$1:$U$6571, you'll see the dates after 9 November in the pivot table:

Forum Discussion

PIVOT TABLE WON'T SHOW ALL DATES

10 Replies

Resources