Put the source variables for rank_current and rank_prior as columns. In other words, temporarily abandoned your calcuated fields and create these new ones.
Right-click on each and select Quick table calculation | Rank
Sort rank as needed.
Cntrl-click and drag your new rank_current to filters and select At Most 10.
This seems to do it for me if I am understanding you correctly.
Understand company policy - Rank is a confusing function - the best source of information I've found is and article that Jonathan Drummey wrote in a series he called Drawing With Numbers - see the link At the Level – Unlocking the Mystery Part 2: Rank Functions | Drawing with Numbers
Thanks for this. The issue appears if the prior rank is outside of the top 10; the row simply won't appear. Say, the offending row has a prior rank of 12, it will only appear if I select top 12, not top 10.
Hi - have found the answer. I need to include a separate filter into the context (add to context). Thanks for your help.