Like this ?
Step 1 - create a rank calculated field
Step 2 - convert the rank calculation to discrete
Step 3 - drop into viz and edit table calculations
HTH 10.4 attached - I also sorted the customer name by sum to push the top clients to the top of the viz.
rank vs rank.twbx 1.2 MB
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.
You should be able to achieve this by putting filters on your customers and regions, and then play around with the order of the pills by dragging them out of sequence.
If you convert the rank calculations to Table (down) then they will be dependent on the pill to the immediate left of the rank pill.
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.