TOPN of Count - Need Help

Md. Altas

Hi All,

I have a requirement where I need to show TOP 5 Customers by the Order Lines.

I have following report in place -

Customer

Customer Site

Order Number

Order Line Number

Ordered Item

Internal Item

Scheduled Ship Date

Actual Ship Date

Shipped Quantity

Shipped Value

I need following view -

Customer

Count of Order Lines

I need to show only Top 5 customers with highest number of Order Lines Shipped

Any help on this is very appreciated !!!

Thanks

cesar.advincula.o

Hello,

Check the criteria section

Check the formula of the Count of the Lines of the document

Check the forumal of the Rank function based in the count:

This is your results, a simple Table object

Kind Regards,

Md. Altas

Perfect !!!!

This was the one I was looking for ...

Thanks a ton

cesar.advincula.o

OK, my friend, good for you!! please mark help an correct answer it is solve your question.

Kind Regards,