Prompt for Top N, Again??? 1

[hneal98]

I was given a solution to this issue before, but it was not the correct solution.

I don't want the first N records, but what I need is for Group A, I need the top submitters of claims. In other words, Group A is submitting 25 claims and Groups B and C are submitting less than 20. I need to show Group A as the top submitter. I am assuming that this would have something counting the records for the groups and then determing, somehowl, which has the top submitions.

I want to be able to have the user determine whether they want the top 5 submitters, top 10, etc.

Thanks again.

 

[lbass]

Is this a reference to thread767-957263? The solution I gave you there should do exactly what you are looking for. Before applying the topN, you would right click and insert a count on {table.claim}. You would suppress all sections except the one where you are showing the count. Then you would go to topN, select "count of {table.claims}" and insert a topN->all->descending order. Then in the section expert, you would use a formula:

groupnumber <= {?topN}

This is not suppressing records, but instead, is suppressing groups that don't meet your criteria. If this isn't working for you, instead of saying the solution is incorrect, you should explain or show a sample of the results you are getting compared to what you would like to see.

-LB

 

[lbass]

Oops, that should have been:

groupnumber > {?topN}

-LB

 

[hneal98]

your lashing is duley noted. Where would I right click to add the claim count? Would it be in the claim group?

 

[lbass]

I was not intending to give you a lashing, and I'm sorry if you interpreted it that way. You have a field like {table.claim} in your details section. You would right click on this field->insert summary->count->check "Insert summaries for all groups". Once you have inserted a summary, the topN sort is available to you.

-LB

 

[hneal98]

ahhh. Got it. Thanks again for your help.