I have created a report showing revenue per country.
In the report, I have used Rank, but now I want to create a variable that only contains the name for the top 10 countries, while the rest of the countries should be labled as "other". This I have done using If + Rank, but I am unable to use it as a drill filter.
I want to use this variable as a drill filter so that the user instead of getting all countries, olnly get to choose from the top 10 revenue countries or all others.
Any ideas how this can be done?