1 of 1 people found this helpful
There are a couple of alternatives to do this, both are described here: Finding the Top N Within a Category | Tableau Software . The article describes the use of INDEX, but you could also use RANK() as shown on this other post: Showing a Nested Top N with "Other" in Tableau - The Information Lab
Hope this helps!
Thanks a lot. Both the methods work just fine but the fact that context filters run before view filters was very helpful.