I have product ID, qty_half price sales, qty_full price sales, $_half price sales, $_full price sales

Any help would be greatly appreciated.

Thanks!

- Thread starter Hoss
- Start date

I have product ID, qty_half price sales, qty_full price sales, $_half price sales, $_full price sales

Any help would be greatly appreciated.

Thanks!

- Joined
- Apr 12, 2005

- Messages
- 9,790

Please demonstrate how you would do it with only three rows - using 1/3, rather than decile.

I have product ID, qty_half price sales, qty_full price sales, $_half price sales, $_full price sales

Any help would be greatly appreciated.

Thanks!

- Joined
- Nov 12, 2017

- Messages
- 3,078

I'm not quite sure what it means for a

I have product ID, qty_half price sales, qty_full price sales, $_half price sales, $_full price sales

Any help would be greatly appreciated.

Thanks!

But if what you mean is that you calculate the total revenue from each (qty_half price sales * $_half price sales + qty_full price sales * $_full price sales) and find the bottom decile of these numbers, I would expect you to just replace each of these in your spreadsheet with the median, and see how the total changes.

This will be equivalent to adding (median sales - mean of bottom decile) to each of those 10%*N numbers, so that would be the total increase in revenue.

A small example, like tkhunny requested but probably a little bigger, showing exactly what you want to compare, would be very helpful.