Create a category depending on the expression result

Tue, 20 May 2014 14:55:41 GMT

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

Re: Create a category depending on the expression result

alexandros17 — Tue, 20 May 2014 15:06:18 GMT

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