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!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sorting Group Totals

Status
Not open for further replies.
MikeCitizens

MikeCitizens

Technical User
Aug 13, 2002
37
US
Hello,
I have a database of transactions for many customers. I need to pull out a report of the Top twenty customers. Top twenty as in revenue. Numerous customers have completed numerous transactions. I created a group to get a total of all profit by each customer. Now I need to pull out the Top twenty profit building customers. How can I do this?? Since I used a group I can't make the profit field the top sort order to pull out the top twenty. Any Ideas would be greatly appreciated.

Mike
 
Sort by date Sort by votes
sorry little new to crystal How do I use top N to complete this?
 
Upvote 0 Downvote
Under Report there is a selection Top N/Sort Group expert (unless you are using old Crystal you didn't mention the version). The expert should take you through the steps you need.

Lisa
 
Upvote 0 Downvote
THANK YOU Have never used the Top N experrt before


Mike
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

socalvelo
  • Locked
  • Question
Group Sorting Distinct Count Minimum
Replies
2
Views
199
socalvelo
socalvelo
cursedkorok
  • Locked
  • Question
Group consecutive dates
Replies
12
Views
447
pmax9999
pmax9999
jlr123
  • Locked
  • Question
Trying to get Select Expert Group f
Replies
7
Views
229
jlr123
jlr123
jlr123
  • Locked
  • Question
date range group by month 1
Replies
8
Views
223
jlr123
jlr123
jchewsmith
  • Locked
  • Question
Crystal Report Pass a variable from a subreport to main report based on a group date for each month 1
Replies
1
Views
130
kray4660
kray4660

Part and Inventory Search

Sponsor

Back
Top