Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Order by a count

Hi,

I created a report to know the number of access of an url.

So the report look like that :

URL Number of access

www.google.ca SUM(of the URL www.google.ca)

I want the most visited to be the first record in my report.

If I have this information in my database.

www.google.ca

www.google.ca

www.google.ca

www.espn.com

So at the end I want this result :

URL Number of access

www.google.ca 3

www.espn.com 1

How I can do that ??? The only thing I can do right now is a group on the URL but if I do that I have this result.

www.espn.com 1

www.google.ca 3

Can I do a formula and group on this formula or the only option I have is to change my query and give the number of access in the query ??

Regards,

Hugo

replied

As you've grouped on the url and have a summary field (count) - now go to Report | Group Sort Expert and make it a TopN report based on your summary (count) for the group (url).

Enjoy!!!

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question