Select inquiry 1

[paladin127]

This may be easy but for some reason I can not seem to figure it out.

I am trying to create a report (CR 10) that will list the top 10 customers in sales for a selected time frame. Basically I want to list customers from a customers table and sum up all of their sales for a specific time period (customerid in the orders table). Orders table fields 'Quantity' and 'UnitPrice' are multiplied and summed up for all of each customers orders.

Can't seem to figure this out. Any ideas?

Thanks.

 

[Katy44]

Have you got a group of each customer with the sum of their orders? (The order price stuff and the customer ID should be in the details, which can be suppressed).
If that's the case, you need to select the Group Sort Expert (the button that looks like a mountain) - and choose "for this group sort top N" and select the parameters you want.

Has this helped? If not, provide a bit more information about exactly where you are stuck.

 

[paladin127]

Hmm. I started something like this but I have another problem. The Group Sort Expert is greyed out. I have the records grouped by customerid.

Why would this feature be disabled?

I think that once I get that, the report should be just what I need.

Thanks.

 

[GJParker]

The group sort is only available for groups containing summaries.

Create the salles summary in the group footer or header and then try the Top N sort baaed on this summary field.

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[Katy44]

Do you have customer ID (or equivalent) and the formula used to calculate the cost of their order in the details section? Then grouped by customer ID and a sum of that formula?
If you have it like this, try summing on, say, quantity for now to see if it doesn't like the fact you are summing on a formula field (although this shouldn't matter).

 

[paladin127]

This all worked out well.

Thanks to all for your help.