reset to "All values" you are filtering on Year so you will only get the correct Jan - end date
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.
The filter property(not-null dates) resets to normal once I change the year.
1 of 1 people found this helpful
Can you check whether the attached workbook works or not?
I make a little change to the Shipdate Filter as below
Please let me know if I misunderstanding.
Does it need to show the name of the month or would 1-12 work? If so, drop your ship date on Filters and select Month. Then change that blue pill to continuous.
Fantastic!! Thanks a lot!!!