1 of 1 people found this helpful
Right clicking the filter and selecting "add to context" will make Tableau resolve the filter before the table calculation. That should solve your filtering issue.
Find my approach as reference below and stored in attached workbook version 9.0
a. Rank: rank(sum([Number of Records]))
b. Show Rank: [Rank]<=[Show Top N Rank]
Mock data testing tested.twbx 36.8 KB
Thanks Wim! for prompt reply