Hello!
I have been struggling to set the range on filters, could you please giude on how to achieve this
Attached is the data table with the following details
Id=Autoincriment number as Primary Key
Month=Month Number(Whole Number)
Quarter=Quarter Number (Whole Number)
Year=Year (Whole number) (ex: year has values from 2000 to 2018)
I am looking for a dynamic 'Start year' filter and an 'End year' filter
Logic: How to limit 'end year' values to three years of range (filter drop-down options) from user selected 'start year'
Ex: If data values are from 2000 to 2018 and if user selects 'start year'=2008 then 'End year' should automatically hide all years in the drop down but only show 2008, 2009 and 2010
Start Year=2001 then end year=2001, 2002 and 2003
