Nth Most Frequent - Need to Display Count of Each

[RedSparks]

I have used the Nth Most Frequent to display each the top 10 most frequent items in a Report footer. Now I need to display the count next to each Nth Most Frequent listed. How do I go about listing this side by side?

Nth Most Frequent Count
1. Drug #1 23 times
2. Drug #2 20 times
3. Drug #3 18 times
4. Drug #4 16 times
5. Drug #5 14 times
and so on...

 

[lbass]

Try inserting a crosstab that uses {table.drug} as the row, and count of {table.field} (whatever you are counting) as the summary. Place this in the report footer. Then click on the upper left corner of the crosstab to select it, and go to ->report->topN/group sort and choose topN. Add in a number for N that is at least as large as the number of groups you want displayed.

-LB