TOPN of Count - Need Help — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

TOPN of Count - Need Help

11
Views
3
Comments
Md. Altas
Md. Altas Rank 3 - Community Apprentice

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


Comments

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    Check the criteria section

    C1.png

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

    C2.png

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

    c3.png

    rank1.png

    This is your results, a simple Table object

    r1.png

    Kind Regards,

  • Md. Altas
    Md. Altas Rank 3 - Community Apprentice

    Perfect !!!!

    This was the one I was looking for ...

    Thanks a ton

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

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

    Kind Regards,