Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Charting Top X of something
Message
General information
Forum:
Visual FoxPro
Category:
Crystal Reports
Miscellaneous
Thread ID:
00663053
Message ID:
00663179
Views:
24
>>Is there an easy way to get CR to chart the top X number of something in a report, then show the rest as "Other"? For example, if I have a report that shows all sales reps and their sales for the year, I only want to see the top 5 of them in a pie chart, with each slice showing the % they added to the total sales. There would also be an "Other" slice for the rest of the sales reps (not in the top 5).
>
>The answer is "Yes". I guess I should have tried this before posting the question. I just assumed it was going to be difficult. After creating the chart, select it. Then go up to Report and select Top N/Sort Group Expert. Now you can select "Top N" based on a field, where N is some number. You can also check a box that says "include Others, with the name...". Very simple.

Sigh...as with most things, it's not as simple as it originally appeared. I'm getting all sort of undesirable side effects from this, most notably the fact that the rest of the data in the report is also shorted to show only the "Top N". The CR help file is completely useless.
-Paul

RCS Solutions, Inc.
Blog
Twitter
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform