How to group slices in a Crystal Report pie chart?
I am trying to show a pie chart showing the sales of a company. However, there are many companies that only have tiny sales that make the pie chart look like garbage.
Is there a way to group such companies into one "other" category?
Chart Expert → Data, then select the "on change" field, then click the "TopN" button. From here you can specify what to do with smaller amounts. I usually group the bottom 5% into an "other" group.