Skip to Content

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

Top N rows using views


     can we show TOP N rows using any of the views(Attribute, Analytic , Calc.) ?.

I have created a calc. view  which is a group by username. The output is something like this:

        USNAM   COUNT

         user123     10

         user121     3

         UserX12     6



I want only  top 5 users . Sql Query for this:'  ................order by "COUNT" desc  limit by 5'; which works fine. But I want the output of view exactly the same way. Is it possible?.




Helpful Answer

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