Create a category depending on the expression result

[#1]

Hi,

I need to create a new category (others) that contains all the countries that have Sales less than 5% of the total.

I used this:

If(sum(Sales)/ sum(<TOTAL> Sales)<0.05, 'Others', Country)

I put this in the Dimension but it doesn't work (it generates an error).

Can you help me please to fix that ?

Thanks

[alexandros17]

You can use dimension limit tab,

check the box Limit, and the option: show only values greater than 5%

then check "others"

Let me know