1 Reply Latest reply: May 20, 2014 11:06 AM by Alessandro Saccone RSS

    Create a category depending on the expression result

      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