I have a problem that I know the brains in here will have a solution for.

I have three variables:
1. item numbers
2. colors
3. qty of items sold

note: not all items have the same colors.

What I am trying to determine is what is my best selling color, but it's
more complicated that than.

Example: The color black sold 10000 items, but black is offered in 200
products. The color Red sold 5000 items and is offered in 50 products. So
although Black sold more individual items than red, red is more successful
because it sold more products per item number.

I currently have the data set up in a pivot table, with the Row field being
the color and the item number (Count of item number) and Qty sold (Sum of
Qty) as the data field.

So how can I rank these colors using this info.

Hope that makes sense.
thanks in advance
Roger