How to include specific value into others on chart?

[EllePL]

Hello

I hope you can help me with my issue.

I have Country dimension and I would like to create TOP10 chart based on some measures. I would like to show Others, but in this Others I would like to always consider country ABC. It doesn’t matter for me if it’s 3rd in rank. Always should be in Others.

I don’t want to exclude from measure or data set, because I still need my total as correct number.

Do you have any idea how to do it in the best way?

Thanks in advance!

[brunobertels]

Hi 

may be this 

assuming sum(SALES) is your mesure :

Aggr(IF(Rank(SUM({<[Country] -= { 'ABC' }>} [SALES]),4)<=10, [Country],Null() ) , [Country])

or

=if(Aggr(Rank(sum({<[Country] -= { 'ABC' }>} [SALES])),[Country])<=10,[GCountry] , Null() )

[EllePL]

Unfortunatelly both solution are not working.

Chart cannot bez diaplayed, because include only negative or null values