The button should apply an advanced filter that compares the current selection of years to the years associated with each ID. The formula I used in the attached file is
='=GetFieldSelections(Year)=concat(distinct Year,' & chr(39) & ', ' & chr(39) & ')'
I hope that helps.
Continum.qvw 157.2 K