Does your data set have data for picking date ranging from 11/7 to 11.30?
Also, you could just manually create a excel data set with 10 or 20 rows, recreate the issue and attach the workbook.
You anchored the filter to Nov 30 and selected 14 days back so it will limit the date range from 11/16 - 11/30
your data is from September so it is not in the range of the filter (i.e. it is filtered out)
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks Jim, but the data I showed an image of is just a snippet and there is recent data. When I anchor the filter to last 14 days, that data shows up. What I want is for data to show up if I select last 14 days with no anchor.