I have chart where I use whole dimension. Problem is that I have several members of dimension which take about 80% of data and several members with small amount of data. Now I want to show this top members and all this others to show as one, or OTHER, to be grouped.
Is it possible to do that and how. I have tried with topCount function but then it shows only those top 5, but not all others.
thanks
Quote from: b737 on 22 Dec 2016 07:43:37 AM
I have chart where I use whole dimension. Problem is that I have several members of dimension which take about 80% of data and several members with small amount of data. Now I want to show this top members and all this others to show as one, or OTHER, to be grouped.
Is it possible to do that and how. I have tried with topCount function but then it shows only those top 5, but not all others.
thanks
You can get the other members using an except() function, then aggregate your measure across this set of members.
MF.
It works great.
Thank you for your help
Also, Cognos 10 has the attribute 'Summerize small items', which will do the same for you. My experience though in my client's version of 10 is that it is bugged according to me, as it shows 'Others' as top item on the bar chart for instance, instead of putting it at the bottom or in the spot correct for the amount in the measure.