How to create slice "Others" in pie?

[Kindness]

Does anybody know how to create a slice "Others" in pie?
The task is the following: when the pie includes small slices, this slices should be displayed as one slice "others".
Thanks

[Arpitagrawal9]

if the slices whose size are small and are needed to be shown as others are fixed than in the data item you are using in the Pie chart create a conditional data item

For ex:

If [ProductID] IN (1,2,3,4,5)
THEN 'Others'
elsef [ProductID]

Hope this helps

[Kindness]

Thanks, Arpit Agrawal!

But, unfortunately, the slices whose size are small and are needed to be shown as others are not fixed.

I experimented  a long and found a temporal solution. I created data item and insert it in the pie as series of pie slices:

Code Select Expand

union (
topCount (
[Dimention_View].[Questions].[Questions].[Section],
3,
[Dimention_View].[Corrective actions].[CA count]
),
member(
total(
[Dimention_View].[Corrective actions].[CA count] within set
except (
[Dimention_View].[Questions].[Questions].[Section],
topCount (
[Dimention_View].[Questions].[Questions].[Section],
3,
[Dimention_View].[Corrective actions].[CA count]
)
)
),
'Other Sections',
'Other Sections',
[Dimention_View].[Questions].[Questions]
),
all
)

and this solution works in simple report. but sometimes it doesn't work.

Therefore I ask for help. May be someone see a mistake in my solution or there is another way to create "Others" slice