1 of 1 people found this helpful
Putting your Year filter into Context should resolve this.
Very useful article on the order things happen within Tableau: Tableau's Order of Operations
You can see a set is calculated before the filters are applied. Putting a filter to context means it happens before the Set is computed.
- Create a set based on ranking
- Hide the remaining out columns
Hope that helps.
Thank you so much!