Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
TOPN of Count - Need Help

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
-
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,
0 -
Perfect !!!!
This was the one I was looking for ...
Thanks a ton
0 -
OK, my friend, good for you!! please mark help an correct answer it is solve your question.
Kind Regards,
0