These examples use Ad Hoc Expressions within a Set Analysis Expressions (marked red).
Sum({$<Year={$(=max(Year))}>}Sales)
Sum({$<Year={$(=Max(Year)-1)}>}Sales)