Disabling 'Others' within Pie Charts

[Dayna]

Hello,

Is it possible, to remove the 'Others' group within Pie Charts - I am currently using a Pie chart to show the top 5 customers on Sales, but as we have more than 5 customers I automatically get the 'Others' segment..

Any help with the above would be most appreciated!!!

Kind Regards,
Dayna

[#2]

You can limited a number of slice of pie chart on the properties.....and not show another values after most 5 customers os Sales.

[Dayna]

Hello Erico,

Many thanks for your fast reply, but unfortunately that is what I've already done - but all other customers get placed under 'Other's. Which I don't want to display...

[quwok]

Hi Dayna,

not sure if a pie chart is the best chart, as pie charts are used to display ratios of the whole. a horizontal bar chart would be an easier option, you can simply sort by their ranking and set the 'Max Visible Number' to 5 on the 'Presentation' tab.

if you are going the pie chart way, your best bet would be to use set analysis to reduce your data set to the top 5 customers. the rank() function should help you identify the top 5. may i refer you to the following post for details.

[#5]

Maybe you can configure the limit area of slice of pie chart in presentation.....did you try that?