Date Pivot Filter

[kerelaweng]

Hi,

I had a pivot table set up that was filtering entries by week ending. It has recently started to list every date of the month available on the filter even though most are not associated with any data. Any idea how I return it to filtering by week ending date only? It is making it pretty much impossible to analyze my data. Screen shot below.

I am using Excel for Office 365 on Windows 10. Happy to attach the file if someone could explain how.

Thanks!

[#2]

@kerelaweng 

Replying on post do you have this menu to attach the file?

[#3]

@Sergei Baklan

No, for some reason it does not show, I have tried multiple browsers.

I can send more screenshots. 

[#4]

@kerelaweng 

For brevity, attach the file as Mr Baklan suggested so it can be fixed, with an explanation on how it was  done.

[#5]

@kerelaweng 

click that to get the full editor and see the file attachment feature: