I have a table that has many products (around 15) with its sales for each store (around 100).
For example :
Product Store Sales
A 1 $10
B 2 $30
What I like to know is the top 10 stores (sales) for each product. I am aware I can sort by Product and Sales. However, there are still 90 stores displayed for each product. Another way to separate each product to a query, sort it and select top 10 and append each product back together. However, this way is not effective, especially I have so many products. Does anyone know how to solve this without using VBA code at all (just query) ?