Re: find top seller

[blading]

Relating to this sales scenario and totalling sales figures for each salesperson and then finding the top seller, what if I have a single sales goal for each salesperson that I want to display along with the totals that have been calculated. How would I do that?

 

[lbass]

Are you the same user that we recommended TopN to in a recent thread? If you have summaries in a group header, and need to add a total sales goal per salesperson, but don't have the goals in the database as a table field, then you could set up a select/case formula like:

Select {salesperson}
Case "Keanu Reeves" : 32000
Case "Halle Berry" : 450000
Case "Bruce Willis" : 586000
Case "Sandra Bullock" : 390000
Default : 0

If you have an earlier version of CR, you might have to set this up as an if-then formula.

-LB

 

[blading]

Thanks! No, I'm not the same person, but my question related to the same type of scenario so I piggybacked onto the saleperson question. I'll give what you stated a try. Thank you.