Thank you for this! Love your content and I am hoping you know how to solve for doing some sort of fixed rank. I always have an issue setting up a rank calculation that does not change when a name filter is applied. An example is rank(sum(profit)) works for a list of employees, and let's say Joe is ranked number 3, but when I filter for Joe's name, his rank is now 1 instead of 3. Any ideas how to solve? I always solve for it in the query but would be nice to have a Tableau fix too. Thank you!
