Selecting Top 10 in Crosstab

[lauriebizz]

hello,
Crystal 10 / SQL

I've got a simple crosstab. I'd like to filter with the top ten results in the row totals. The object to to list the top ten customer with the higest rate of late shipments. Any ideas? Current crosstab looks like this:

Customer # shipped Late
Acco 2
Amerock 1
Armstrong 2
Atlas 4
Belwith 407
Bluelinx 36


Thanks-
Laurie

 

[GJParker]

go to the report menu -> group sort expert ->select Top N and set this to 10

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[lauriebizz]

Got it - Thanks!