Pivot Table Date Field drop down list is not showing all dates in source data

[NancyB]

Hello - My pivot table has the date field as a filter. The table was started this year and shows each date individually (e.g. 23-Dec) which is good as I want to display data by individual day. My date will continue into next year. I've added future dates into the date sources and turned on "Show items with no data" in the Field Settings for the date field. But individual dates past 31-Dec do not show in my drop down list. The last item to choose is ">1/4/2021". How can see all the dates from my source data to continue on into next year? Thank you for any guidance.

 

[shift-del]

Hi NancyB

I guess you have grouped your date field. Remove the grouping.

 

[NancyB]

Thank you but the Group Options are greyed out for the Date field.

 

[shift-del]

You may to need to move it from the report filter area to the rows area before remove the grouping.

 

[NancyB]

Thank you- I'm all set!!