top 10 best and worst performing vendors 2

[Dausa67]

I have a report that has 31,000 line items. The report (and hopefully chart) has to be based on the top ten best performing vendors and the bottom ten worst performing vendors for the year 2008. It has to be grouped by the month. The first question that I have is how do I group the report so it only shows the ten best and worst vendors for each month for the year of 2008? It should show 120 line items for the entire report. I have tried grouping by need date for each month but anything I try after that ends up wrong. Any suggestions on what I might try next?

Clay

 

[lbass]

I would insert a group #2 on {table.vendor} and then do a group sort (report->group sort) in descending order on the vendor group tab->summary. You need to insert a running total {#grpcnt} that does a distinctcount of {table.vendor}, evaluate on change of group: vendor, reset on change of group: month. Then use a suppression formula to eliminate the middle range values:

{#grpcnt} in 10 to distinctcount({table.groupfield})-10

I would insert separate charts for top10 and bottom10 in the month group footer.

-LB