In the Expression
Sum( {<MajorCategory={'Revenue'}, Year={$(=Max(Year))}>} Net)
Where would you put the $:: to make it accept selections made on the "Year" list box since you are already defining a value for Year?
UPDATE:
I figured it out, it would look like
Year={$(=Max({<Year=$::Year>}Year))