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
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
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:
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