Recent content by winiblues

Hi John, Thanks for the reply. I was able to get the query to rank the sales. However, I'm unsure as to how to assign a percentile. Your example would work fine if there were only a few ranking, however I have rankings up to 100,000 for which I need to assign a percentile. Example provided...

I am trying to create a query which will rank each sku for each supplier by sales. Once ranked then I want to be able to assign a percentile of 0.2 for the top 20% of skus for a given supplier, then 0.4 for the next 20% of skus for a given supplier and so on. I've attached a screen shot of the...