Hi
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.
Ex:
List:
US
France
....
Other
Any ideas how this can be done?