Thanks in advance for your help.
I'm applying a date filter (slider showing range of dates, user slides lower and upper bound) on several worksheets. The filter seems to be working, but the title which pulls the start and end date from this filter, is only working on the first filter.
Here's the title format on each of my worksheets-
for period starting <AGG(Date(WindowMin)(Title))> and ending <AGG(Date(WindowMax)(Title))>
Calculations as follows-
DATE(WINDOW_MAX( MAX( [Date variable]) ))
DATE(WINDOW_MIN( MIN( [Date variable]) ))
On the very first sheet, the filter works and the title updates as expected. On all other worksheets, using the same exact source data and calculations and filter, the filter works but the title displays
for period starting ALL and ending ALL
instead of showing dates, ALL is displayed.
Any idea why this could be happening?
Difficult to answer without actually looking at the workbook. Could you attach a packaged workbook?