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 ?