see the attached approach
it returns this
I added a filter to sheet 2 that looks like this
set the filter on the filter shelf and set to True
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.
checking 3_v10.2.twbx 28.7 KB
The answer is pretty easy and simple:
1) Create a calculated field:
IF ATTR([Date]) = WINDOW_MIN(MIN([Date])) OR ATTR([Date]) = WINDOW_MAX(MAX([Date]))
Done. Updated worksheet is attached.
Pls mark my response as correct and helpful.
checking 3.twbx 27.4 KB