Skip to Content

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

Order by a count


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

So the report look like that :

URL Number of access SUM(of the URL

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

If I have this information in my database.

So at the end I want this result :

URL Number of access 3 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. 1 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 ??



Former Member

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).


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