Help with weighted average by percentile on multiple products

[tbyji2]

Good evening all,

In the attached data set I have 4 products, with different /unit pricing, and sales volume. I would like to calculate the weighted average price, by product and percentile.

So for Product A, I would like to calculate the weighted average price of the top 20, 21-40, 41-60 etc. percentile of prices, then in the highlighted yellow area put the corresponding volume in for that product and percentile. This way if the top 20% of sales orders based on unit pricing have lower volumes we can easily see it. Each product should be looked at individually, so product B's $/unit shouldn't be compared to product A's.

Any help is appreciated.

[Glenn Kennedy]

Please describe how you would do this manually... and do so for one or two cells, so we can see what you mean.

I don't understand what you expect to see.