Jan 07 2021 03:34 PM
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,
Jan 07 2021 11:28 PM
@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.
Jan 08 2021 11:25 AM
Bit another behavior will be if add data to data model creating PivotTable.