Skip to Content
0
Former Member
Feb 26, 2013 at 07:41 PM

Top 20 Product Comparison Query

102 Views

I need to write a query that will look at all of our products and report back against the top 20 products based on sales value totals.

I want to be able to select a BP and for the Top 20 products we sell as a company to display with the total amount in sales value and unit quantity to show next to each product based on what that customer has purchased in the past 12 months or a date range i can set.

The BP must be an option for the user to enter when running the query.

Hope someone out there can help me.