Dynamic Dimension string error

[#1]

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))

[swuehl]

What do you mean with 'wouldn't work'? Seems quite ok as your calculated dimension, besides I would add a DISTINCT qualifier and a space:

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

[fkeuroglian]

Hi can you put an example or tell what error do you have?

thanks

Fernando