I am trying to pull only the top 5 in a group. I have used the "Top N/Sort Group Expert" function to pull the top 5 and that works, but when I click the check box for putting everything else into "Others", it pulls back that 6th group and doesn't rename it as "Others". Is there something I am missing/doing wrong?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Need Help With Top 5 In Group With Others
- Thread starter Wease7
- Start date
Make sure you place the "Group #1 Name" field on that group section (NOT the actual field/formula you are grouping on).
That should fix it.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
That should fix it.
Cheers,
- Ido
CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question