I have a event showing start year and end year. I am showing filters on this start and end year.
Suppose an event is on start year=2006 and end year= 2010 . In the filter only when start year=2006 and end year=2010 only, the record is considered. But I need to consider the record for all years in between. i.e. if end year != start year, then record need to be counted for each year.(for start year=2007 and end year=2008)