Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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))
Hi can you put an example or tell what error do you have?
thanks
Fernando