how do i figure out most wins while grouping various data

[aspnetuser]

I have a report grouped on id number and username. at the grouping for username, I sumed up a field called totals wins for each username. I need to only display the username with the maximum amount of wins. I tried using the group selection formula editor but I always get a running sum error. Any suggestions on which formula to use?

 

[paulmarr]

You can use the Group Sort Expert - located under the Report menu - to choose a TopN sort where N is a number you can specify (i.e. 1) and then make sure the "others" tickbox remains unticked - thus showing the user with the max wins.

Cheers,

paulmarr

 

[kskid]

Click on Report -> Top N/Sort Group Expert.
On the Group Sort, select Top N from the dropdown and insert 1 in the box following "where n is"
Uncheck if you don't want to see the others.

Cheers,

-LW

 

[aspnetuser]

That works fine but sometimes users have a tied amount of max wins. In that case, I need to use another field called difference. The real winner is the user that is closest to 0 when they tie the amount of max wins...