TopN Counts greater than 1 1

[socalvelo]

CR XI

I am trying to set the TopN in the Group Sort Expert to return the top 5 records with ties. But I don't want groups with single records (or counts of 1) because there are several of these.
In other words I want group record counts greater than 1.

Can someone suggest a formula that can be placed into the TopN X-2 editor or would this be something placed in the Group Expert?

 

[pmax9999]

In the Group Selection Formula section, enter:

Count({Table.YourCountField},{Table.YourGroupField}) > 1

Hope this helps

Cheers
Pete

 

[socalvelo]

Pmax, Thank you. That solved my issue.