Rank Calculation with Drill Through Filters
I have a leaderboard that ranks salespeople by a calculated measure, and I want that ranking to only be based upon that absolute reference. However, when I click on categories to filter the data, it then re-ranks the salespeople by that drilled through subset. I want it to show just the salespeople that are a part of that subset, but I also want the ranking to remain absolute to the original measure.
I tried a few different variations of the calculation and nothing worked. In Excel, dollar signs on the reference we want to remain unchanged works, but I'm not sure how to do this in Targit. Thanks in advance to anyone who can help!