Hey Peter,

thanks for the reply

I really just need to show one customer vs an entire region or all regions

this isn't a great example with this data, in my production data most customers buy 70+% of the total assortment.

what I need to be able to do is select one customer and one region, where the customer might not be in the region we are comparing it to

then just look at the top n items for each the selected region and the selected customer.

hope that makes it a little more clear.

that's where I went with the example you sent.

let's say we want to compare Alex Russel's top selling items vs the South and West region

this breaks the example since Alex doesn't sell in the South or West.

ideally I could see what from those regions are selling best vs what Alex is selling best.