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!!!
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...
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.
