Need to join Other to collective Others (Rest of Data)

[#1]

Hi there guys, hopefully someone can shed some light as I have been trying to find a workable solution for sme time and its really doing my head in.

I work for an Emergency Response company, for their claims model they have all the procceced claims against the respective medical aid companies.

We have a claims volume bar chart which lists the top 5 medical aid companies (with %), now in the backend system there are the companies as well as "Other". When generating the bar chart it displays the top 5 like so:

Med Co1

Med Co2

Med Co3

Other

Med Co4

Others

"Other" is an actual value in the database and "Others" is obviously the collective everything else.

What would be the best way to get everything except the top 5 into "Others", effectively combining Other and Others?

I have tried decreasing the sliver number but that only works on a global level, as soon as you drill down Other and Others creap back in.

Any help would be greatly appreciated.

[#2]

Hi,

try to use this expression in the Sort tab of your graph (i guess it is currently sorted on Company dimension) :

=aggr(rank(sum (if ( Company <>'Other', Volume, 0)) ) , Company)

Hope this help.

Gilles

[gandalfgray]

Hi b

Do you mean that you want to disregard the "Other" medical aid company?

Or do you mean that you want to force "Other" into the Others group even if "Other" is one of the top 5?

/gg

[#4]

Thanks Giles I will give it a try and see.

GG - Yeah I would like to force Other and Others as the collective rest together.