how do i remove this from my filter in pivot table

Occasional Visitor
Good afternoon, I'm trying to filter the data and these 2 dates appear, at the beginning and end ... someone knows how to remove them.

Thank you,

2 Replies

@BARBAS1095 Excel has grouped the dates in your data by year. The first and last items in the filter list show the first and last (+1 day) dates in your data set, indicating that you are looking at grouped dates. Select only the first or last item and your pivot table will come up blank, indicating that there is nothing before or after these dates.


Bit another behavior will be if add data to data model creating PivotTable.