Top Select 1

[jenni]

I have been using this Top feature, but the problem is that if I choose top 10, and the values
in the 10th and 11th place are the same, the list returns Top 11.

For example:
Top 3 products sold
1. Boots 5
2. Shirts 4
3. Pants 2
4. Hats 2

Whenever the amount of the last position from my Top select the same value as the next
position has, I don not get only the top 3, but 4,5,6, or sometimes more.

How can I get access to really cut off the list where I want it to.

 

[ghubbell]

Hello Jenni!
Ah ha! this is an issue we've been working on over at thread703-60297 . My argument is that your top 3 does truly contain four or more things if your top 3 is based on the count. If you want it to be the top 3 results regardless, make another regular "select" query based off of this query and again ask for the top 3. Enjoy! Gord
ghubbell@total.net

 

[jenni]

Thanks Gord. You saved me once again!

Jenni