SOLVED

Filter shows old dates even when not in current data

New Contributor

I have a file with several pivot tables where the date fields when attempting to filter shows dates back to 2012.  The data only has 2021-2023 information in it.  Is there a way to refresh the filter field to only show the dates of the data in the report?

2 Replies
best response confirmed by SRossetti (New Contributor)
Solution

@SRossetti 

Click in a pivot table. On the PivotTable Analyze tab of the ribbon, click Options.

Activate the Data tab of the dialog.

Set 'Retain items deleted from the data source' to None, then click OK.

Refresh the pivot table.

S2039.png

Thanks. That worked!!