topic Re: How to include specific value into others on chart? in App Development

How to include specific value into others on chart?

EllePL — Fri, 26 Jul 2024 08:45:15 GMT

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!

Re: How to include specific value into others on chart?

brunobertels — Fri, 26 Jul 2024 09:02:52 GMT

may be this

assuming sum(SALES) is your mesure :

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

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

Re: How to include specific value into others on chart?

EllePL — Fri, 26 Jul 2024 10:43:21 GMT

Unfortunatelly both solution are not working.

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