Top N Query

[Tony]

Hello,

Is there a way to create a query that will return the Top
N (2) values for a specific aggregated field (i.e.
Country):

Example,

Customer, Country, Units Sold

(would like to return the following)

John Doe, US, 52,000
Steve Smith, US, 48,000
Suzy White, UK, 68,000
Dave Hill, UK, 38,500
Jose Ruiz, MX, 22,800
Maria Sanchez, MX, 46,200

I've set the Top Value to 2 in the query properties, but
this only returns the Top Value = 2 for the entire data
set. I hope this makes sense!

Thanks in Advance,

Tony

 

[John Vinson]

Hello,

Is there a way to create a query that will return the Top
N (2) values for a specific aggregated field (i.e.
Country):

First create and save the aggregate query, and then base a Top Values
query on the stored Query. AFAIK there's no way to do it in a single
query.