Hi all
I have a dimesnsion with names of operators and a measure with the number of connections made by each one. I want to represent in a pie chart the top 10 operators based on number of connections. But I want to see the absolut %s not the distribution among the top10. So I must add a category accounting for the connections made for all other operators.
How do I create a dimension with the top 10 operators plus the word “others” to accout for all other.
I’ve tryed the following but desktop Intelligence makes it a measure so i can’t use it as my charts xxs…
=If (Rank( ,<Cnx_Count>) <11) Then Else “OTHERS”
Any Idea?
Many thanks
ds9
ds9 (BOB member since 2006-04-27)