Skip to Content
0
Former Member
Nov 27, 2011 at 12:47 PM

List top 10 countries in filter and the rest as "others"

33 Views

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?