CODEWITHSUNDEEP
crystal-reportsreporting
John Hunter
John Hunter

Reputation: 4142

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

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?

Upvotes: 1

Views: 3065

Answers (2)

dotjoe
dotjoe

Reputation: 26940

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.

Upvotes: 4

Galwegian
Galwegian

Reputation: 42247

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.

Upvotes: 0

Related Questions