Hi,
I have simple problem that is not easy to me at all.
I have a table SHOPS with 2 columns, SALES and ADDRESS
Basically my task is to show:
- how many shops and which ones specifically contribute to the top 10% of total sales
- how many shops and which ones specifically are in the top 10-20% range of total sales
- how many shops and which ones specifically are in the top 20-30% range of total sales
I tried my best but everytime it analyzes the sales value of each shop and gives me result for each shop separatety.
However I want it to give me the list of all shops that contribute to each range by their sales combined. So I think it needs to calculate the total sales at first, then compare sales of each shop to the total sales, then sort it descendingly, then give me the list of the shops which sales combined fit in the ranges.
dummy example..
let's say total sales are 100K
then..
top 10% is 10K in total (easy)
top 10-20% is also 10K in total (shops that have lower sales but combined equal 10K)
top 20-30% is also 10K in total (shops that have even lower sales but combined also equal 10K)
sales value for shops:
shop A = 6K
shop B = 4K
shop C = 3K
shop D = 2,8K
shop E = 2,2K
shop F = 2K
shop G = 1,8K
etc
I need to see that..
in the top 10% there are..
shop A = 6K
shop B = 4K
in the top 10-20% there are..
shop C = 3K
shop D = 2,8K
shop E = 2,2K
shop F = 2K
etc
So in the end in the top 10 there will be just few shops
in the top 10-20% there will be more cause they generate less sales
and in the top 20-30% there will be even less cause they generate even less sales
but I need to see which are those (by address in this example)
it's been driving me nuts for hours now..
please help
