Is there a way to pull only the top 100 (or whatever #) items by sales $ within my query? I have the sales $ listed in descending order, but there are over 10000 items and rather than manually pull out the top 100, I'd like to have it automatically.
I don't want it to necessarily rank them to where I get 1,2,2,4, but rather 1,2,3,4....100.
TI hope this is clear -thanks!
I don't want it to necessarily rank them to where I get 1,2,2,4, but rather 1,2,3,4....100.
TI hope this is clear -thanks!