retrieve top 1000

building reports webintelligence
1

How do I restrict my report to only show the top 1000 in desc order?

Thanks!

iuphim (BOB member since 2008-11-19)

2

Assuming you want to display the top 1000 by ranking something like revenue or items sold, etc. you can use the RANK function in your query.

jwhite9 :us: (BOB member since 2006-07-28)