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

    Create a category depending on the expression result



      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 ?