How do I group slices in my Crystal Report pie chart?

Question

I am trying to display a pie chart that shows sales by company. However there are a lot of companies that only have a tiny sales which makes the pie chart look rubbish.

Is there a way to group companies like this into a single "Other" category?

Answer 1

You could always make two pie charts from your data - one showing the main players and the other showing a blow-up of your smaller company data.

Answer 2

Chart Expert -> Data then select your "on change of" field then click the TopN button. From here you can specify what to do with the smaller amounts. I usually group together the bottom 5% into an "other" group.