2 Replies Latest reply: Jun 20, 2014 8:52 PM by Fernando Keuroglian RSS

    Dynamic Dimension string error

      No idea why this wouldn't work, it does until I add the bolded portion:

       

      IF(AGGR(RANK(SUM([AMOUNT USD])), [SUPPLIER NAME]) <= 10,AGGR(RANK(SUM([AMOUNT USD])),[SUPPLIER NAME]), 'Other '&(Count(TOTAL[SUPPLIER NAME])-10))