RANKX Works Halfway

Hi All, I'm using RankX to rank distributors by orders. When I show a table with the list, it works as expected. However, I am working on a dashboard and want to filter on a distributor, and see thei...