R
RJB
So I need to build a matrix, and I suspect "SUMPRODUCT" will be friend on
this, but boy, is it scary.
I have a list of SKUs, the customer(s) who bought each, and the quantity
each customer bought:
SKU 1, WalMart, 5000
SKU 1, Target, 3500
SKU 2, KMart, 4200
SKU 2, WalMart, 6700
SKU 2, Dollar Tree, 2100
etc...
I'd like to:
- Rank my customers based on total purchases, and then break them into
deciles;
- List each SKU down the left hand column, then, going across, show how much
of each product was bought in each decile
In other words, for SKU 1 - how many dollars were spent on that SKU by my
"Top Ten" customers, by my "Second Ten", and so on.
(Note - "Top Ten" is my top ten PERCENT)
Any quick and easy way to pull this off? I have in my mind what I'd like
tosee, but don't have an example of where else something similar has been
done, so links are a big help as well.
Thank you,
this, but boy, is it scary.
I have a list of SKUs, the customer(s) who bought each, and the quantity
each customer bought:
SKU 1, WalMart, 5000
SKU 1, Target, 3500
SKU 2, KMart, 4200
SKU 2, WalMart, 6700
SKU 2, Dollar Tree, 2100
etc...
I'd like to:
- Rank my customers based on total purchases, and then break them into
deciles;
- List each SKU down the left hand column, then, going across, show how much
of each product was bought in each decile
In other words, for SKU 1 - how many dollars were spent on that SKU by my
"Top Ten" customers, by my "Second Ten", and so on.
(Note - "Top Ten" is my top ten PERCENT)
Any quick and easy way to pull this off? I have in my mind what I'd like
tosee, but don't have an example of where else something similar has been
done, so links are a big help as well.
Thank you,